Lookup Object

DTS Programming

DTS Programming

Lookup Object

The Lookup object allows a data pump consumer, for example a DataDrivenQueryTask2, DataPumpTask2 or ParallelDataPumpTask object, to specify one or more named, parameterized query strings that allow a transformation to retrieve data from locations other than the row being transformed. For example, a Lookup object might reference data in a Microsoft® Excel worksheet.

Collections
Properties Collection
Properties
ConnectionID Property Parent Property
MaxCacheRows Property Query Property
Name Property  

See Also

Adding DTS Lookups and Global Variables

DataDrivenQueryTask2 Object

DataPumpTask2 Object

Lookups Collection

ParallelDataPumpTask Object