Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Execute SQL Task Editor (Parameter Mapping Page)
Collapse the table of content
Expand the table of content

Execute SQL Task Editor (Parameter Mapping Page)

Updated: 15 September 2007

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.

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 that you have selected for 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: Running Parameterized SQL Commands section in Execute SQL Task

Parameter Size

Provide the size of parameters that have a 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.

Release History

15 September 2007

New content:
  • Described the Parameter Size option.

5 December 2005

New content:
  • Described requirements for parameter naming.

Community Additions

ADD
Show:
© 2015 Microsoft