Chapter 21. Using the Script Component

IN THIS CHAPTER

Introduction to the Script Component

Creating a Source Adapter

Creating a Destination Adapter

Creating a Transformation

Asynchronous Outputs

“I’VE DONE A DEMO FOR MY TEAM AND THE CONSENSUS WAS THAT SSIS IS ‘AWESOME,’ ‘RIGHTEOUS,’ AND ‘FUNKADELIC.’”—SCOTT KIM

As you can see from the preceding chapter, a lot of stock transformations and adapters ship in the box. Even so, at times, you’ll still need to access some data or perform a transformation that isn’t supported with the stock components. The Script Component is provided as an intermediate step between available stock components and writing a custom component.

Introduction to the Script Component

Like the Script Task, the Script ...

Get Microsoft SQL Server 2005 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.