Transform Data Task Properties (Source Tab)
Use this tab to set the properties of and query source data.
Options
Description
Type a description of this Transform Data task.
Table/View
Select a table or a view from the data source specified on the connection. There is no guaranteed ordering of rows.
SQL query
Specify that an SQL statement retrieve the data from the data source. Type the SQL statement.
Parameters
Map global variables to input parameters by specifying an SQL query that includes parameters (using one or more question marks as a parameter placeholder).
Preview
View the data in the selected source table.
Note If your source connection is to a dBase data source, and you specify an SQL query, the source data may not be available for viewing.
Build query
Use the Data Transformation Services (DTS) Query Designer, a visual query building tool, to create the SQL statement to execute.
Browse
Specify the location of an SQL query to execute.
Parse query
Check the syntax of the SQL statement prior to execution.