DTS Programming
Lookups Collection
The Lookups collection is a group of Lookup object definitions. A Lookup object defines a named, parameterized query string that allows a transformation to retrieve data from a location other than the row being transformed.
Remarks
In a Microsoft® ActiveX® script, the lookup should be referenced with the Execute method of an element of the DTSLookups collection. If the lookup rowset has more than one column, the Execute method returns a Variant array. The script may need to iterate through the array to use multiple values.
Prototype (C/C++)
HRESULT GetLookups(IDTSLookups **pRetVal);
See Also
Adding DTS Lookups and Global Variables
DTSDataPumpLookups Collection
Execute Method (Script)
Lookup Object