Parameter Mapping (Output Parameters Tab)

DTS Designer

DTS Designer Help

Parameter Mapping (Output Parameters Tab)

Use this tab to specify the global variables that will contain the data returned from the query.

Options

Output Parameter Type Area

None
Specify that no data be returned from the query, or, if data is being returned, that no data be stored in a global variable.
Row Value
Specify that each column returned from the query be stored in a separate global variable. The grid will populate with the corresponding number of columns in the results set. The columns will be listed in order as Parameter1, Parameter2, and so on. Automatic mapping to existing global variables is done ordinally. If you do not want to save the value of a column being returned, type <none> in the Output Global Variable field. To change which column is being stored in which global variable, use the list in the Output Global Variable cell to select the global variable that should hold the data. If the global variable you want to use does not exist, click Create Global Variable. After the global variable has been created, it is now ready to be used in the parameter mapping.
Rowset
Specify that you want to store the data returned from the query in a single global variable. The global variable will hold the entire rowset. This global variable can be used in subsequent tasks as a disconnected Microsoft® ActiveX® Data Objects (ADO) recordset. If no data is returned from the query, then the global variable will contain nothing. If the global variable you want to use does not exist, click Create Global Variable. After the global variable has been created, it is now ready to be used in the parameter mapping.
Rowset List
Specify the name of the global variable that will hold the rowset.

Parameter Mapping Area

Parameters
Display a read-only list of the columns being returned from the SQL statement, if applicable.
Output Global Variable
Specify the global variable to contain the data in the column when the data is being returned as a row value.
Create Global Variable
Display the Global Variables dialog box, where you can type a new global variable for the Data Transformation Services (DTS) package.

See Also

Using Parameterized Queries in DTS

Execute SQL Task

Using Global Variables with DTS Packages