Data Transformation Services Package

Packages are the main objects of Data Transformation Services. Each DTS package defines one or more tasks to be executed in a coordinated sequence. The DTS package can be created manually by using a language that supports OLE Automation, such as Microsoft® Visual Basic®, or interactively by using the Data Transformation Services wizards or DTS Designer. A DTS package can be stored in:

Using DTS includes:

• Defining DTS packages in Enterprise Manager or an application using the DTS API. DTS packages include these components:
  • Connection objects defining each source or destination OLE DB data source.
  • Task objects defining the specific actions to be performed.
  • Step objects defining the sequence in which tasks are to be performed.
• Storing the DTS packages in:
  • DTS COM-structured storage files.
  • The Microsoft SQL Server™ msdb database.
  • Microsoft Repository.
• Executing DTS packages using:
  • The dtsrun utility.
  • The DTS Designer.
  • The DTS Import and Export Wizards.
  • SQL Server Agent to run a scheduled job.
  • A COM application that calls the Execute method of the DTS Package object.

See Also