ParameterDirections Enum

Definition

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

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.

Applies to