[Excel Destination [320]] Error: SSIS Error Code
-
[Excel Destination [320]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager 2" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
am getting this error when i try to use excel as a destination and . It says they may be error message posted before but there are no error posted. I have a file in a shared folder with .xls extension and but I don’t have Microsoft office installed in my server but I can access the file from any of machine that have office installed so am sure the file exist . am wandering if it is because I don’t have office installed in the server or some other problem …
help
-
I'm not sure what the Excel destination component is based on, but I'm guessing it uses the same old Microsoft Jet provider. Do you have MDAC installed on this machine? Is this 64 bit machine or it is 32 bit? If it is 64 bit machine, make sure you run your package in 32 bit mode because the Jet provider is available only in 32 bit mode.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
-
Got it…. All I had to do was go to the package property and in the debugging option set run64bit run time to false ---- thanks for the hit
-
Did you do this in BIDS? If yes, this will not be enough when running your SSIS package under SQL Job Agent Step. You have to use "Execute Process" job step and explicitly select the 32 bit DTEXEC located by default in:
\\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply