Connection Objects

Each DTS package contains zero or more connections that are used by these types of tasks:

• DTS Data Pump task
• Execute SQL task
• Data Driven Query task
• Custom task

There are three types of connection objects:

• Data source connections

  Specify information about source and destination OLE DB data sources. The information includes server names, format and location of the data, and passwords. The connection is established by the first task that uses the connection. A data source connection can specify information about an ODBC data source when using the Microsoft OLE DB Provider for ODBC.

• File connections

  Specify information about source and destination files. The information includes format of the data, file names, and location.

• Microsoft Data Link connections

  Requires either loading a data link file (.udl file), or setting the data link file properties for an OLE DB provider.