O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

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

Integration Services Packages

As mentioned earlier, when you develop an ETL solution by using SSIS, you’re going to be developing packages. SSIS packages are the basic unit of development and deployment in SSIS and are the primary building blocks of any SSIS ETL solution. As shown in Figure 14-1, the package is at the heart of SSIS; having SSIS without packages is like having the .NET Framework without any executables. An SSIS package is, in fact, a collection of XML that can be run, much like an executable file. Before we examine the core components of an SSIS package, we’ll take a brief look at some of the tools and utilities available to help you to develop, deploy, and execute packages.

Tools and Utilities for Developing, Deploying, and Executing ...

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