Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Tasks that Copy and Manage Data

SQL Server 2000

Data Transformation Services (DTS) includes several tasks designed to copy and manage data and meta data.

Task Description
Bulk Insert Task Copies large amounts of data from a text file into a Microsoft® SQL Server™ table or view.
Execute SQL Task Runs SQL statements during package execution and saves data that is the result of a query.
Copy SQL Server Objects Task Copies or creates SQL Server objects such as tables, views, indexes, and constraints from one instance of SQL Server to another.
Transfer Database Objects Tasks Copies entire databases, jobs, error messages, logins, and master database stored procedures.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.