What Are the Data Transformation Services (DTS)?

  • Josef Finsel


Life before the Data Transformation Services (DTS) was much like that of the butterfly. It was a time-consuming process of writing programs to read data from text files or another source and then to write the data to a database. Utilities like the Bulk Copy Program (bcp) can pump data into or out of SQL Server, but mastering the arcane parameters of bcp could take a long time. Fortunately, in SQL Server 7, Microsoft introduced DTS. Suddenly, getting data into or out of SQL Server became a lot easier.


Global Variable Enterprise Manager Custom Task Multiple Revision Query Analyzer 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Josef Finsel 2001

Authors and Affiliations

  • Josef Finsel

There are no affiliations available

Personalised recommendations