Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Transform Data Task Properties (Source Tab)

SQL Server 2000

Use this tab to set the properties of and query source data.



Type a description of this Transform Data task.


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.


Map global variables to input parameters by specifying an SQL query that includes parameters (using one or more question marks as a parameter placeholder).


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.


Specify the location of an SQL query to execute.

Parse query

Check the syntax of the SQL statement prior to execution.

See Also

Transform Data Task

DTS Connections

Using Parameterized Queries in DTS

© 2015 Microsoft