Integration Services


SSIS has changed significantly since SQL Server 2000. The result of this rearchitecture is a truly enterprise-ready, scalable, and extensible ETL application.

In this chapter, you learned about some of the features introduced in SSIS, as well as the new integrated development environment (IDE). You learned about the new division of labor within the SSIS Designer: Control Flow and Data Flow. You examined all the tasks and features available for use both in the Control Flow and Data Flow toolboxes. You were introduced to the improved logging features, variables, and debugging features. Lastly, you reviewed how you can deploy and schedule SSIS packages as SQL Server Agent jobs.

This chapter just barely scratches the surface of SSIS. Coverage of SSIS could easily fill an entire book of its own (and has certainly done so in previous versions), so be on the lookout for a future Apress title devoted to SSIS.


Data Flow Precedence Constraint Integration Service Design Surface Event Handler 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Thomas Rizzo, Adam Machanic, Julian Skinner, Louis Davidson, Robin Dewson, Jan Narkiewicz, Joseph Sack, Rob Walters 2006

Personalised recommendations