Microsoft provides a graphical tool for creating and executing packages called DTS Package Designer. This tool allows you to create and execute local packages or packages residing in a central repository.
While there are multiple ways to start DTS, the simplest way is to follow these steps. The image below explains this topic in greater detail.
Bring up SQL-EM
Select the server group
Select the server
Select Data Transformation Services
Select either local or repository package
Right-click to bring up the New Package menu
After you select New Package, the DTS Package Designer will start up. There are three main areas of the DTS Package designer:
There are standard tasks, data objects, and workflow items for use with the DTS Package Designer.
While all tasks and all data objects require similar information, each has its own distinct use and will prompt you for specific information needed for the task or to access the data.
Tasks and data objects
The following MouseOver illustrates the different standard tasks and standard data objects used with the DTS Package Designer.
After you have created a package, you will normally want to save it. The DTS Package Designer allows you to save a package to the local server, a
central repository, or a file. To save a package, select the Package menu, then select Save.
In the next lesson, you will learn how to schedule and run a package.