Transform Data Task Properties (Lookups Tab)
TOC
Collapse the table of content
Expand the table of content

Transform Data Task Properties (Lookups Tab)

SQL Server 2000

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.

Options

Name

Type a name for the lookup.

Connection

Choose an existing connection from the list on which to execute the lookup query.

Cache

Type a value for or view 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 the Data Transformation Services (DTS) Query Designer. You can also 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

Removes the highlighted lookup query from the Lookups table.

See Also

Lookup Queries

Configuring a Simple Lookup Query

Using ActiveX Scripts in DTS

Show:
© 2016 Microsoft