Hi CozyRoc,
Thanks for your reply.
I got the following error from the SSIS package log:
The AcquireConnection method call to the connection manager "QuickbooksExtract" failed with error code 0xC0202009.
where the QuickbooksExtract is an Excel Connection Manager.
I did some research through the internet and found that this happend because there's no 64-bit Jet provider which is used to deal with the excel files and I will need to run the package under 32-bit dtexec.exe in order to get this problem solved.
Any idea on how can I get this done?
Please advice.
Thanks.