Chapter 9
Scripting in SSIS
WHAT’S IN THIS CHAPTER?
- Selecting your scripting language and getting started
- Adding assemblies to SSIS Script objects
- Understanding Script Task usage
- Understanding Script Component usage
- Using external SSIS objects from within a script
- Using events and logging in debugging scripts
Scripting is the Swiss Army knife of SSIS. As shown in previous chapters, many different SSIS features are available out-of-the-box. If you need to do something that you just can’t find anywhere else, you will find additional functionality in three features: the Script Task, the Script Component, and expressions. Expressions, covered in Chapter 6, are small scripts that set properties. The other two scripting concepts provide access into a scripting development environment using Microsoft Visual Studio Tools for Applications (VSTA) that enables SSIS developers to script logic into packages using Microsoft Visual Basic 2010 or Microsoft Visual C# 2010 .NET code.
In this chapter, you will learn the differences between these script components and when you should use one over the other. You’ll also learn all about the various scripting options available and how to use them in your package development tasks to control execution flow, perform custom transformations, manage variables, and provide runtime feedback.
INTRODUCING SSIS SCRIPTING
If you think of scripting as something that compiles at runtime and contains unstructured or unmanaged coding languages, then scripting in ...
