Professional SQL Server™ 2005 Integration Services

6.15. Summary

This chapter attempted to stick with the everyday nuts-and-bolts uses of some of the tasks and transforms so that you'll at least be aware of how your old DTS has changed and get a feel for what is now available. Overall there was only enough space for a few simple examples, but you looked at some background concepts of variable scope and the use of expressions in runtime property management.

When you put down this book and begin applying these tasks and transforms to real problems, you may find that your packages are becoming quite involved. Not only do the components need to work together, but you also need to provide error handling, to log activity, and to address the issues of moving packages from environment to environment. Refer to the case study in Chapter 19 to see a more complete picture of all these pieces coming together to transform, load, and then process three completely different formats of payment data. This case study is unique in its use of the SSIS environment as both an ETL and a programming solution to a business problem. The case study also makes use of both the Script task and the Script Component transform to retrieve and set variables that control both the logic flow and the transformation flow in the package. Both the Script task and the Script Component transform are indispensable when you need to do something for which a ready-made task or transform does not yet exist. Read on to Chapter 7 to discover the power and capabilities of the ...