Business Intelligence And Data Warehousing Software Directory

Data Transformation Services (DTS) in SQL Server 2000

Details: Microsoft SQL Server 2000 Data Transformation Services (DTS) ETL tool overview article introduces the DTS tools available for creating and executing DTS packages in SQL server 2000. It guides users through an introduction of the DTS designer interface, describes DTS tasks and shows how to save and execute DTS Packages.
This DTS technical tutorial contains a number of Microsoft SQL server DTS examples with screenshots.

The sample tutorial shows how to:
  • design data transforming tasks
  • implement data copying and data managemenet tasks
  • Run tasks as jobs from within a package
  • Set task precedence using workflows
  • Address: