Chapter 9

Scripting in SSIS


  • 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.


If you think of scripting as something that compiles at runtime and contains unstructured or unmanaged coding languages, then scripting in ...

Get Professional Microsoft SQL Server 2012 Integration Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.