DTS packages can be created using import/export wizards, the DTS Package Designer, or a COM interface. The import/export wizards provide the simplest mechanism for moving data into or out of a data warehouse, but the transformation complexity is limited by the wizards’ scope. For example, only single sources and single destinations are allowed in the wizard.
The DTS Package Designer exposes all the capabilities of DTS through an easy-to-use, visual interface. Within the DTS Package Designer, users can define precedence relationships, complex queries, flow of control, and access to multiple, heterogeneous sources.
The DTS Package Designer provides a graphical environment for describing data flow and package execution.
Finally, applications can define and execute DTS package programming through a COM interface. This approach is primarily used by ISVs who want to use the features of DTS without requiring a user to define the packages separately.