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