O'Reilly logo

Professional Microsoft SQL Server 2012 Integration Services by Chris Rock, Mike Davis, Jessica M. Moss, Erik Veerman, Brian Knight

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required