Chapter 8Integration Services

It seems strange that the minute you get data into a database, you are deluged with requests to take it out and put it into another one. It is also common to import data from other databases, files, and systems into your databases. Microsoft’s SQL Server Integration Services (SSIS) serves as the primary engine and design environment for everything from simple imports and exports to a full-fledged extract, transform, and load (ETL) platform for the most demanding business intelligence (BI) landscape.

However, it is not just about moving data back and forth. SSIS has an intuitive graphical design environment that you can use to create powerful programs that perform maintenance on your databases, talk to other systems ...

Get Administrator’s Guide to SQL Server 2005 now with O’Reilly online learning.

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