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 | Â |