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.