DTSDataPumpLookup Object
From DTS Programming
DTS Programming
DTSDataPumpLookup Object
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.
Properties
| LastRowCount Property | Name Property |
Methods
| AddToCache Method | RemoveFromCache Method |
| Execute Method |
Remarks
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.