ParameterDirections Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Defines the type of the parameters available to use in the SQL statement that the Execute SQL task runs.
This enumeration supports a bitwise combination of its member values.
public enum class ParameterDirections[System.Flags]
public enum ParameterDirections[<System.Flags>]
type ParameterDirections = Public Enum ParameterDirections- Inheritance
-
ParameterDirections
- Attributes
Fields
| Name | Value | Description |
|---|---|---|
| Input | 1 | The parameter is an input parameter that passes a value to the SQL statement. |
| Output | 2 | The parameter is an output parameter that returns a value to the Execute SQL task. |
| ReturnValue | 4 | 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.