Data Driven Query Task Properties (Lookups Tab)

DTS Designer

DTS Designer Help

Data Driven Query Task Properties (Lookups Tab)

Use this tab to define a lookup query. Before defining a lookup query, you must first create connections for the source, binding, and lookup tables, and specify the source and binding tables. For more information, see Lookup Queries.

Options

Name

Type a name for the lookup.

Connection

Select an existing connection on which to execute the lookup query.

Cache

Specify the number of lookup results saved in a cache. Caching is especially useful with lookups if the number of rows being transformed is large and you are querying on a small number of rows in the lookup table.

Query

Build the lookup query in Data Transformation Services (DTS) Query Designer. Alternatively, you can paste the query from a text editor into the SQL pane.

Add

Create a new lookup query, which will be listed as a row in the Lookups table.

Delete

Remove the highlighted lookup query from the Lookups table.

See Also

Configuring a Simple Lookup Query

Using ActiveX Scripts in DTS