Introduction

A complete database solution requires data to be integrated from a variety of sources. One of the greatest challenges facing business today is that important business information exists in multiple locations and in different formats. As an industry, we have empowered business leaders and information workers with access to corporate data and powerful analysis tools. With access to so much information, decision makers need one indisputable version of data. A reliable ETL (extract, transform, and load) process is the backbone of business-critical data consolidation and business intelligence (BI) services used to lead and support business direction. Microsoft SQL Server 2005 Integration Services (SSIS) provides a foundation to design ...

Get Microsoft® SQL Server™ 2005 Integration Services Step by Step 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.