Export (0) Print
Expand All

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft