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