damien.gulluni (10/7/2013)

---

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 one now is to use a script task to open the file in excel and use a macro to remove the noisy commas. But using SSIS 2005 I can't find Microsoft.Office.Interop.Excel.dll to use Interop within VB.net ...

Regards,

Damien