Chapter 10. Importing, Exporting, and Transforming Data
In this chapter: |
|---|
Creating Packages with the SQL Server Import and Export Wizard |
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 2005 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™ 2005 Administrator's Pocket Consultant 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.
