Summary

In this chapter, you learned about the available scripting options in SSIS. You learned how to use the expression language built into SSIS to set properties dynamically. You saw how the expression language is used in some tasks to perform their work. You learned how the Script task works and how it can be used in your package. Finally, you learned how to use the Script Component to transform your data.

Experiment with the scripting features of SSIS until you have a good handle on them, and you will find all kinds of uses for them. For more information on anything covered in this chapter, refer to SQL Server Books Online.