INF: Getting Started with Data Transformation Services (DTS)

• Microsoft SQL Server version 7.0

SUMMARY

Data Transformation Services (DTS) is a SQL Server component used to import, export, and transform data from different data sources. The information in this article is meant to help you get started in using DTS.

MORE INFORMATION

One of the best ways to learn how to effectively use DTS is to run the DTS Import Wizard and/or the DTS Export Wizard. For example, instruct the Wizard to copy the authors and titles tables from the pubs database to the northwind database, dropping the tables before creating them. Take a look at all the options on the screens along the way, perhaps changing one or two things to see what happens. Next, save the job to your local SQL Server and schedule the job as well. Have it execute the job so you can see what happens.

Now, go into the DTS portion of SQL Server Enterprise Manager and double-click your DTS package under the Local subtree. This opens the DTS Designer. Right-click everything (the icons, the connectors, and the background as well) to see their options. Start dragging icons from the left side into the background and see what information is needed for each item. In the main area, select two icons that are not already connected, right-click one, select Workflow and then specify Success, Failure, or Completion.

For samples, install the DTS samples from the SQL Server 7.0 CD by choosing a Custom Install and clicking Samples (it is the last item on the Components list; you must scroll down to get it).

REFERENCES

Additional query words: SEM SSEM ent man entman

Keywords : kbSQLServ700
Version : winnt:7.0
Platform : winnt
Issue type : kbhowto kbinfo