Chapter 7. SQL Server Integration Services

SQL Server Integration Services (SSIS) is a new subsystem of SQL Server 2005 that replaces SQL Server 2000 Data Transformation Services. SSIS packages are commonly used to merge data from heterogeneous data sources, populate data warehouses, clean and standardize data, build business intelligence into a data transformation process, and automate administrative functions. In this chapter, you learn how to use the Business Intelligence Development Studio (BIDS) to design and construct SSIS packages. You also learn how to use the interface to secure sensitive data stored in packages, troubleshoot package execution using checkpoints, and deploy completed SSIS packages to other servers.

Exam objectives in this chapter: