DTS gives you the ability to import, export, and convert data between data sources, either locally or remotely. For example you could export data from your SQL server to Microsoft Excel or Access and vice versa. You could even move data between two SQL servers.
The most common uses of DTS is to move data between a development and production environment, or to create a front and back-end to a database structure.
MSDN – Data Transformation Services (DTS) in SQL Server:
Micrsoft TechNet DTS FAQ:
SQL Server 2005 ToolKit (Includes DTS wizard for Express users):
Trouble logging in? Simply enter your email address below and we will send you an email that will allow you to reset your login.
For faster and more reliable delivery, add email@example.com to your trusted senders list in your email software.