DTS Programming
Insert Method
The Insert method inserts an object in an ordinal position in a collection.
Applies To
Syntax
collection.Insert Position, Object
| Part | Description |
|---|---|
| collection | Expression that evaluates to an collection in the Applies To list |
| Position | Ordinal position of the object to insert |
| Object | Object to be inserted |
Remarks
The required type of Object depends on the collection to which it is being inserted.
| Collection | Object |
|---|---|
| Columns | Column Object |
| Connections | Connection Object Connection2 Object |
| GlobalVariables | GlobalVariable Object |
| Lookups | Lookup Object |
| PrecedenceConstraints | PrecedenceConstraint Object |
| Steps | Step Object Step2 Object |
| Tasks | Task Object |
| Transformations | Transformation Object Transformation2 Object |
| TransformationSets | TransformationSet Object |
The Insert method does not create an object. It adds an existing object to its collection. Typically, you create the object with the New method of the collection.
Prototype (C/C++)
HRESULT Insert(
VARIANT Position,
Interface *Object);