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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
