| DTS has migrated into an enterprise level Extract Transform and Load (ETL) tool. This session will serve as an introduction to the significantly enhanced Data Transformation Services in SQL Server 2005. There are so many changes that you won’t even recognize DTS if you used it in SQL 2000. We’ll begin the discussion with the new development environment and then follow up with package development and the notion of a pipeline architecture. Our package development will cover transforms, checkpoints, multiple configurations and error handling.
|