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 |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2013-02-20 : 12:52:35
|
| i want to load excel to my db , but the ssis throw me this error:[Excel Source [2]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed.i have bids 64 bit,excel 64 bit and my system is 64 bitwhat is the cause? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2013-02-21 : 05:05:39
|
| but i want to run the package as 64 bit, and i even installed excel 64 biti download this file by this link:http://www.microsoft.com/en-us/download/details.aspx?id=13255 |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2013-02-28 : 03:42:53
|
| i installed Microsoft Access Database Engine 2010 Redistributable but i still don't see "Microsoft.ACE.OLEDB.12.0" in the ole db list in ssis. |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2013-03-06 : 15:00:04
|
| any help please.... |
|
|
|
|
|
|
excel file