Chapter 12. SQL Server Integration Services Overview
IN THIS CHAPTER
In a typical enterprise environment, data is often stored in different formats and schemas in disparate sources. It is often necessary to extract and convert this data from different data types and formats into a unified format to be stored in a single destination or processed further for reporting. This task of moving, manipulating, integrating, cleaning, validating, and summarizing data in SQL Server 2005 can be achieved by using the technology called SQL Server Integration Services (SSIS). Formerly known as Data Transformation Services ...
Get Microsoft® SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition) 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.