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.
Options
Input Global Variables
Select the global variable whose value you would like to use to replace the parameter marker at run time.
Parameters
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.