Hi,

I have solved my issue using the following:

- create a script task that will open my csv files with excel (yes you can do that ;)) and execute a macro...

You can open csv in excel and I obviously know the difference between excel and csv files.

I don't think that using StreamReader class will help me a lot.

Yes Raunak.

Damien

Anyway this is not the concern of my request to say if SSIS is responsible or not ...

What I am looking for, and thank you again for your time, is...

Yes preview is cool, but I can only see the first 100 rows when the problem appears latter on the file.

Regards,

Damien

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

Yes sure.

You will find here all the component I use:

- Flat File Connection Manager (format:delimited; text qualifier: "; header row delimiter: {CR}{LF};

- Flat File Source;

- Data Conversion Transformation (used...

Hi Raunak,

First of All, thanks for your reply. I already tried with a Flat File Connection; but the error occurred directly on the Flat File Source.

The solution I am working...