Chapter 15. Using the Script Task

IN THIS CHAPTER

The Script Task Environment

Using the Script Task

Script Task Samples

“THAT’S SO COOL, MAN!”—ASHVINI SHARMA

The Script Task warrants an entire chapter because it is such an important part of the flexibility and extensibility model for Integration Services. Integration Services ships with a rich set of tasks covering a broad range of features, but there always seem to be a few things people want to do in their packages that the stock tasks don’t support. The Script Task nicely fills the holes left by the stock tasks and sports its own Visual Studio Designer with a rich set of development bells and whistles, such as object browsing and IntelliSense. If you are only familiar with the DTS ActiveX ...

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.