CHAPTER 10
Script Component As Source
This chapter focuses on the Script Component as a source. There are a lot of different sources available in the Data Flow Task, but sometimes you get, for example, files that are not properly formatted to make them readable for the Flat File Source. And what about using the Script Component to generate random test data if you don’t have data to test your data flow?
Flat File with an Uneven Number of Columns
Some .csv files have rows where not all the columns at the end are filled. Instead of having empty columns, the columns have been omitted. This causes some strange behavior in the Flat File Connection ...
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.
