Hands-On Microsoft SQL Server™ 2005 Integration Services

Summary

This chapter covered the basic components used for building a workflow in an SSIS package. Integration Services provides connection managers that help various tasks in the package to establish connections to the external data stores. Variables provided in SSIS are different from those in DTS 2000 as they can have scope now and are categorized as system variables that you cannot create and modify—they are readonly, and the user-defined variables that you create to meet the needs of the package. Precedence constraints are also enhanced beyond DTS 2000, as they can include expressions to consider along with execution results of the precedence executable. Finally, the most powerful feature of Integration Services is its ability to evaluate ...