Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-04-25 : 10:20:04
|
| [EXL_Beta_Source [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager 1" failed with error code 0xC00F9304. There may be error messages posted before this with more information on why the AcquireConnection method call failed.[SSIS.Pipeline] Error: component "EXL_Beta_Source" (1) failed validation and returned error code 0xC020801C.[Connection manager "Excel Connection Manager 1"] Error: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-25 : 14:30:04
|
| the error message is obvious. You're trying configure a 32 bit Excel connection manager in a 64 bit sql server installation. You need to use 64 bit equivalent provider instead------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-04-25 : 16:03:21
|
| So how do you change it. Isn't it through properties? |
 |
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-04-25 : 16:07:13
|
| So how do you change it. Isn't it through properties? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-25 : 16:10:42
|
| Nope. Do you've corresponding provider that works for 64 bit? if not you need to first download and install it.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|