If you’re crazy enough to be using SSIS to import information from an Excel workbook into a database, you may get an error like this:

Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.

The AcquireConnection method call to the connection manager “Time Series XLSX” failed with error code 0xC00F9304.

The solution is to go into project properties, select the “Debugging” page and set Run64BitRuntime to false.

Note: I’m not normally this crazy, but when a job needs to be done, someone has to do it. Sigh.

Comments

blog comments powered by Disqus
Next Post
Parameter Attributes and more  05 Feb 2011
Prior Post
Validation can be the enemy  27 Jan 2011
Related Posts
Using Constructors  27 Feb 2023
An Inconvenient API  18 Feb 2023
Method Archetypes  11 Sep 2022
A bash puzzle, solved  02 Jul 2022
A bash puzzle  25 Jun 2022
Improve your troubleshooting by aggregating errors  11 Jun 2022
Improve your troubleshooting by wrapping errors  28 May 2022
Keep your promises  14 May 2022
When are you done?  18 Apr 2022
Fixing GitHub Authentication  28 Nov 2021
Archives
February 2011
2011