September 3, 2009 at 7:48 am
I have created a load of packages to extract data from Excel or csv. Nothing fancy. Tested (definately the csv ones) and all ok.
Got the admin guy to log on to the server (remote desktop) and open BIDS and execute the job. All is well. (Yep I know not very good way of running SSIS)
I go upstairs this morning and it does not work for the admin guy (same way through the remote desktop) . This time its loading Excel files. It cannot open the Excel data source! Since the last test I have added package configurations (SQL SERVER). I have seen the admin guy open SSMS and change the value for the file location in the SSIS config table (connected to it via windows authentication same as in ssis). All appears well. When we run the package then it cant find the file.
Observations so far
1. Both myself and the admin guy are opening the same solution.
2. I am running it throigh BIDS and he remote desktops to the server and uses BIDS.
3. He can go to the directory and open the file edit it and save it. So surely he has windows access to the XL file.
3. When he logs into SSMS he can edit and update the table holding the file name.
4. We removed the package configuration and that did not help.
Any suggestions, is there something I am missing?
Ells.
😎
Error Message:
[EDS Pop Female [17]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
September 4, 2009 at 8:30 am
Are you by chance running this in 64-bit mode? Excel services can only run in 32-bit mode, so simply make sure you run it using 32-bit mode for execution (the dtexec found in the '90' directory, whereas the '100' is 64-bit)
Josef Richberg
2009 Exceptional DBA
http://www.josef-richberg.squarespace.com
http://twitter.com/sqlrunner
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply