O'Reilly logo

Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services by Régis Baccaro, Joost van Rossum

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 12

image

Script Component As Destination

This chapter focuses on the Script Component as a destination. There are a lot of out-of-the-box destinations available, but sometimes you need something special—a custom flat file with extra headers and footers, a record divided over multiple rows, and an XML destination.

But be careful when using the Script Component as a destination. Because records are processed row by row, it is probably not a good idea to insert a lot of data into a database with stored procedure calls or a lot of single query commands. The OLE DB destination with the fast load on is likely a lot faster; and if you really need ...

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