Tasks that Copy and Manage Data

Data Transformation Services

Data Transformation Services

Tasks that Copy and Manage Data

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.