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 10

image

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

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