The DTSDataPumpLookup object provides information about columns in a Data Transformation Services (DTS) lookup query to a Microsoft® ActiveX® script. The DTSDataPumpLookup object belongs to the DTSDataPumpLookups collection.
DTSDataPumpLookup returns a variant or an array of variants (if multivalued) corresponding to the sequence of columns in the single output row resulting from the 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.