O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required