CorinaThong (12/20/2009)
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.
I have another question for you. When you say you have web service, does the code you have implemented to execute the package run inside library (DLL) or it is part of an executable? Is it ASP.NET module?
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
