Microsoft® SQL Server™ 2005 Integration Services Step by Step
by Hitachi Consulting Paul Turley Joe Kaspizak, Scott Cameron, Satoshi Iizuka, and Pablo Guzman
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, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access