I fully agree when you have the control of the file produced .. The file comes from Business Object world and I have only choice between tab, semicolon, and comma which are all delimiter that can be used in the file I receive.

But for me the main problem is that the excel engine can handle that case while SSIS cannot.

Regards,

Damien