Chapter 11. Importing, Exporting, and Transforming Data

Whether you need to move data from a legacy system to a new system permanently or you want to continually move data back and forth for data warehousing, Microsoft SQL Server 2008 Integration Services (SSIS) should be your first choice. With Integration Services, you have access to an Extraction, Transformation, and Loading (ETL) platform that can be fully customized for your specific application and is optimized for high-performance data movement and transformation. You can use Integration Services to copy and transform data ...

Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with O’Reilly online learning.

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