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