Chapter 21. Integration Services

Moving data between data stores can sometimes be a challenging task, especially when multiple data structures are involved or data needs to be changed before it’s placed in a new location. The goal of SQL Server 2005 Integration Services, also known as Integration Services or SSIS, is not only to simplify such data transfer task but also to provide rich functionality in support of more complex extract, transform, and load (ETL) requirements for data warehousing. The goal of this chapter is to introduce you to the key concepts of Integration Services. We’ll explore how to build basic packages using the new design environment and how to use some ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.