In this course, you will learn how to use Data Transformation Services (DTS) in Microsoft SQL Server 2000. This course presents DTS as an integral part of a data warehousing solution. You will learn how DTS works, how to set up DTS packages, and how to use the graphical tools for creating and maintaining packages. You will also learn how to use the various components of DTS packages: connections, tasks, steps, and global variables. Learning DTS not only benefits those who design and build data warehouses and data marts, but also anyone who works with data that is stored in different formats throughout an organization. This course shows you how Data Transformation Services can be used in any situation involving data transfer or maintaining the consistency of data.
In this course, you will learn to...
This course is appropriate for database administrators and database developers who want to learn how to use the tremendous functionality of Data Transformation Services. Knowledge of SQL Server and the Enterprise Manager tool is a prerequisite, but you do not necessarily have to be using SQL Server for all of your database needs to benefit from this course.
Consultants, Trainers and Content Producers. Learn more about us.
Explore other training options...