DTS Programming

Columns Collection

A Columns collection is a group of Column objects containing a description of all available meta data about a column in a data source. This includes name, description, data type, precision, scale, nullability, and numeric base.

Properties
Count Property Parent Property

Methods
Add Method Item Method
AddColumn Method New (Columns) Method
Insert Method  

Remarks

Columns collections are referenced by the properties of the objects indicated in the table.

Property Object
DestinationColumns Property
SourceColumns Property		 Transformation2
DeleteQueryColumns Property
InsertQueryColumns Property
UpdateQueryColumns Property
UserQueryColumns Property		 DataDrivenQueryTask2
TransformationSet
DestinationColumnDefinitions Property DataDrivenQueryTask2
DataPumpTask2
TransformationSet

See Also

Adding DTS Column Objects

Column Object

DataDrivenQueryTask2 Object

DataPumpTask2 Object

Transformation2 Object

TransformationSet Object