damien.gulluni (10/7/2013)
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 to find a solution with all the constraint I have.
Actually the process is fully manual and I am trying to automate it with SSIS.
In order to open the file with excel in SSIS I am trying to use a script task. But now the issue I am facing is that I cannot find Excel Interop component to be used in vb.net script (SSIS 2005 version).
Regards,
Damien
It's a .csv file, not an Excel file. You can use the StreamReader class to read the file.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP