Parameter Mapping (Input Parameters Tab)

DTS Designer

DTS Designer Help

Parameter Mapping (Input Parameters Tab)

Use this tab to specify the global variables to be assigned to the parameters in the SQL statement. The parameters, indicated by question marks in the SQL statement, are parsed left to right and are represented in the Parameters column as Parameter1, Parameter2, and so on.


Input Global Variables

Select the global variable whose value you would like to use to replace the parameter marker at run time.


View a read-only list of parameter markers from the SQL statement.

Create Global Variables

Display the Global Variables dialog box, where you can create new Data Transformation Services (DTS) package global variables.

See Also

Using Parameterized Queries in DTS

Execute SQL Task

Using Global Variables with DTS Packages