ParameterDirections Enumeration

ParameterDirections Enumeration

 

Defines the type of the parameters available to use in the SQL statement that the Execute SQL task runs.

This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.

Namespace:   Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask
Assembly:  Microsoft.SqlServer.SQLTask (in Microsoft.SqlServer.SQLTask.dll)

[FlagsAttribute]
public enum ParameterDirections

Member nameDescription
Input

The parameter is an input parameter that passes a value to the SQL statement.

Output

The parameter is an output parameter that returns a value to the Execute SQL task.

ReturnValue

The parameter is a return code that returns an integer value from a stored procedure to the Execute SQL task.

Parameters are used to exchange data between the Execute SQL task and the queries or stored procedures it calls.

Return to top
Show:
© 2016 Microsoft