ParameterDirections Enumeration

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)

public enum ParameterDirections

Member nameDescription

The parameter is an input parameter that passes a value to the SQL statement.


The parameter is an output parameter that returns a value to the Execute SQL task.


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.

Return to top
© 2016 Microsoft