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

	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. For more information about parameters, see Parameters (Database Engine) and Returning Data by Using OUTPUT Parameters.