SQL Server Integration Services

SQL Server Integration Services

by Bill Hamilton
Released March 2007
Publisher(s): O'Reilly Media, Inc.
ISBN: 9780596557706

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

SQL Server 2005 Integration Services (SSIS) lets you build high-performance data integration solutions. SSIS solutions wrap sophisticated workflows around tasks that extract, transform, and load (ETL) data from and to a wide variety of data sources.

This Short Cut begins with an overview of key SSIS concepts, capabilities, standard workflow and ETL elements, the development environment, execution, deployment, and migration from Data Transformation Services (DTS).

Next, you'll see how to apply the concepts you've learned through hands-on examples of common integration scenarios.

Once you've finished this Short Cut, you'll have the background and understanding you need to start building your own SSIS integration solutions.

Product information

  • Title: SQL Server Integration Services
  • Author(s): Bill Hamilton
  • Release date: March 2007
  • Publisher(s): O'Reilly Media, Inc.
  • ISBN: 9780596557706