Hi,

just an idea. Maybe is an indirect way, but what about to use a Script Component or a Script Task and use C# to proccess the csv file. There is a method to open a file in Read mode in the System.IO.File. There are also several code snippets in the Web to read csv files with C# like here.

The problem with the flat file source is you cannot configure to many parameters, therefore you do not have too many options with it.

Hope this helps.

Kind Regards.