Use the Parameter Mapping page of the Execute SQL Task Editor dialog box to map variables to parameters in the SQL statement.
To learn about this task, see Execute SQL Task and Working with Parameters and Return Codes in the Execute SQL Task.
-
Variable Name
-
After you have added a parameter mapping by clicking Add, select a system or user-defined variable from the list or click <New variable...> to add a new variable by using the Add Variable dialog box.
Related Topics: Integration Services Variables
-
Direction
-
Select the direction of the parameter. Map each variable to an input parameter, output parameter, or a return code.
Related Topics: Parameters (Database Engine)
-
Data Type
-
Select the data type of the parameter. The list of available data types is specific to the provider selected in the connection manager used by the task.
-
Parameter Name
-
Provide a parameter name.
Depending on the connection manager type that the task uses, you must use numbers or parameter names. Some connection manager types require that the first character of the parameter name is the @ sign , specific names like @Param1, or column names as parameter names.
Related Topics: Working with Parameters and Return Codes in the Execute SQL Task
-
Parameter Size
-
Provide the size of parameters that have variable length, such as strings and binary fields.
This setting ensures that the provider allocates sufficient space for variable-length parameter values.
-
Add
-
Click to add a parameter mapping.
-
Remove
-
Select a parameter mapping in the list and then click Remove.
Reference
Execute SQL Task Editor (General Page)
Execute SQL Task Editor (Result Set Page)
Concepts
Integration Services Error and Message Reference
Other Resources
Accessing and Changing Database Data
Transact-SQL Reference (Database Engine)
Help and Information
Getting SQL Server 2008 Assistance