DTS Programming

TransformationSet Object

The TransformationSet object defines the transformations to be performed on the columns of a component rowset in a hierarchical rowset by the Parallel Data Pump Task object.

Collections
Lookups Collection Transformations Collection
Properties Collection  

Properties
DeleteQuery Property InsertQueryColumns Property
DeleteQueryColumns Property LastRow Property
Description Property MaximumErrorCount Property
DestinationColumnDefinitions Property Name Property
ExceptionFileColumnDelimiter Property Parent Property
ExceptionFileName Property ProgressRowCount Property
ExceptionFileOptions Property RowsComplete Property
ExceptionFileRowDelimiter Property RowsInError Property
ExceptionFileTextQualifier Property UpdateQuery Property
FetchBufferSize Property UpdateQueryColumns Property
FirstRow Property UserQuery Property
InsertQuery Property  

Remarks

The TransformationSet object includes a Transformations collection and contains all the information necessary to copy and transform a component rowset, such as data driven queries and their parameter collections, row and error counts, and exception file information.

The ordinal position of the TransformationSet object in the TransformationSets collection determines the component rowset to which the object is mapped. For more information about the mapping process, see TransformationSets Collection.

See Also

ParallelDataPumpTask Object