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.
Assembly: Microsoft.SqlServer.SQLTask (in Microsoft.SqlServer.SQLTask.dll)
| Member name | Description | |
|---|---|---|
| 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.
Show: