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. |