O'Reilly logo

Microsoft SQL Server 2005 Integration Services by Kirk Haselden

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

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