CHAPTER 12
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 ...
Get Extending SSIS with .NET Scripting: A Toolkit for SQL Server 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.
