DTS Programming

New (ID) Method

The New method creates a new object for a collection from a ProgID or CLSID.

Applies To

Connections Collection	Transformations Collection
Tasks Collection

Syntax

[Set object =] Collection.New( ID )

Part	Description
Collection	Expression that evaluates to an object in the Applies To list
object	Object variable to receive reference to created object
ID	ProgID or CLSID of object to be created

Remarks

The required type of object depends on the collection to which it is being added:

Collection	Object
Connections	Connection Object Connection2 Object
Tasks	Task Object
Transformations	Transformation Object Transformation2 Object

The New method for the collections in the Applies To list creates a new object based on the ProgID or CLSID of the corresponding class. The New methods for other collections use different parameters and syntax.

There are version-dependent and version-independent forms of a ProgID. Typically, the version-dependent form looks like name.version. The version-independent form typically has name only, without the .version, although that form is not required. The version-independent form should be used unless you need a feature of a particular version.

Prototype (C/C++)

HRESULT New(
BSTR bstrID,
ObjectInterface **RetVal);

Examples

To create a new connection using the Microsoft® OLE DB Provider for ODBC drivers in Microsoft Visual Basic®, use one of the following forms.

By version-independent ProgID:

   Set objConnection = objPackage.Connections.New( "MSDASQL" )

By version-dependent ProgID:

   Set objConnection = objPackage.Connections.New( "MSDASQL.1" )

By CLSID: