O'Reilly logo

Microsoft by Hilary Cotter, Ross Mistry

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3 Creating Packages and Transferring Data with Integration Services

SQL Server 2008 Integration Services (SSIS) provides data movement and transformation capabilities for SQL Server. Just as in SQL Server 2005, SSIS replaces SQL Server 2000 Data Transformation Services (DTS). SSIS provides for the following data services:

Image   Extraction

Image   Transformation

Image   Loading

This triumvirate of data services is frequently referred to as ETL. The process ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required