The DTSDataPumpLookup object provides information about columns in a DTS lookup to an ActiveX script. The DTSDataPumpLookup object belongs to the DTSDataPumpLookups collection.
DTSDataPumpLookup returns a variant or an array of variants (if multi-valued) corresponding to the sequence of columns in the single output row resulting from execution of a query. If multiple rows are returned, only the value of the first row is returned in the output variant. An application can call LastRowCount to assert that only one row was returned.
| AddToCache Method | RemoveFromCache Method |
| Execute Method |
| LastRowCount Property | Name Property |