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 |
|
petey84
Starting Member
14 Posts |
 Posted - 2011-01-24 : 17:14:30
|
| Hi,I have set up a data flow using the SSIS Import and Export Wizard to export data from SQL server 2005 to Microsoft Access 2010. However when I test the connection during the wizard it looks like my connections are in place however when I execute the package I get the following error messages:Errors:[Destination - Person [22]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "E:\Test\ExcelTest\AdventureWorksTest.accdb" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. [DTS.Pipeline] Error: component "Destination - Person" (22) failed validation and returned error code 0xC020801C. [DTS.Pipeline] Error: One or more component failed validation. Error: There were errors during task validation. [Connection manager "E:\Test\ExcelTest\AdventureWorksTest.accdb"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". Can someone please tell me where I am going wrong?I am pretty new to SSIS, so any kind of troubleshooting I can do is appreciated.Could this be a issue with me running the SSIS package in 64 bit and microsoft access is 32 bit? |
|
|
petey84
Starting Member
14 Posts |
Posted - 2011-01-26 : 12:56:14
|
| Hello,I know I have had no replies but alot of reads to this post so just for your information I have resolved the issue.The issue has to do with the debug running in 64bit, so all I did was go into the project properties and select 'False' for Run64BitRuntime option.Hope this helps people with similar issue. |
 |
|
|
jlhook
Starting Member
1 Post |
Posted - 2012-09-10 : 09:38:50
|
| I just ran into a similar problem. Your solution was the answer. Thank you so much for taking the time to post the solution!John |
|
|
|
|
|
|
SSIS error exporting to Access 2010