Chapter 11. Importing, Exporting, and Transforming Data

Whether you need to permanently move data from a legacy system to a new system or 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 customized for specific applications and is optimized for high-performance data movement and transformation. You can use Integration Services to transform data or to copy data to or from almost any ...

Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd 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.