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)
Syntax
'Declaration
<FlagsAttribute> _
Public Enumeration ParameterDirections
'Usage
Dim instance As ParameterDirections
[FlagsAttribute]
public enum ParameterDirections
[FlagsAttribute]
public enum class ParameterDirections
[<FlagsAttribute>]
type ParameterDirections
public enum ParameterDirections
Members
| 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. |
Remarks
Parameters are used to exchange data between the Execute SQL task and the queries or stored procedures it calls.