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 |