Chapter 6. Scripting Tasks

After completing this chapter, you will be able to:

  • Create, modify, and execute custom behaviors, using the Script Task, Script Component, and ActiveX Script Task.

  • Write custom code in the Microsoft Visual Studio for Application (VSA) development environment, using Microsoft Visual Basic .NET.

  • Incorporate external Microsoft .NET assemblies and COM into the Script Task and Script Component.

  • Implement error-handling code, using TRY...CATCH...FINALLY statements.

  • Access SSIS built-in capabilities such as Variables, Events, and Logs from custom code in the Script Task and Script Component.

In the previous chapters, you learned how to create a package by using Control Flow tasks and containers as well as Data Flow components. However, ...

Get Microsoft® SQL Server™ 2005 Integration Services Step by Step 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.