DTSDataPumpLookup Object

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.

See Also

DTSDataPumpLookups Collection

Lookup Object