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