Transform Data Task Properties (Source Tab)

DTS Designer

DTS Designer Help

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.

See Also

Transform Data Task

DTS Connections

Using Parameterized Queries in DTS