asked on

SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR

I created SSIS packag from sql server 2008 64bit and source was access dataabse. I successfully created ssis package and tested the connection on source and destination databases. I imported the SSIS package onto Integration Serivice and i also executed package from there and it worked. It failes from SQL Agent job. It wont run. I also checked the "Use 32bit runtime" on execution option tab, it still failes.

OS is Windoiws server 2008 64 bit
Destination: SQL - SQL 2008 standard 64 bit
Source: Access Database

Error from Job:
Executed as user: xxxx\xxxxx. Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:53:00 AM Error: 2010-02-04 10:53:01.43 Code: 0xC0209303 Source: PoundTow Connection manager "SourceConnectionOLEDB" Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered -- perhaps no 64-bit provider is available. Error code: 0x00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". End Error Error: 2010-02-04 10:53:01.43 Code: 0xC020801C Source: Data Flow Task 1 Source - Pound Tow Log Main [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2010-02-04 10:53:01.43 Code: 0xC0047017 Source: Data Flow Task 1 SSIS.Pipeline Description: component "Source - Pound Tow Log Main" (1) failed validation and returned error code 0xC020801C. End Error Error: 2010-02-04 10:53:01.43 Code: 0xC004700C Source: Data Flow Task 1 SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2010-02-04 10:53:01.43 Code: 0xC0024107 Source: Data Flow Task 1 Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:53:00 AM Finished: 10:53:01 AM Elapsed: 0.608 seconds. The package execution failed. The step failed.

Reza Rad

sql server agent service must run under administrator account, or same account you created ssis package with it.

Anandhi1

ASKER

Yes. It running under administrator account. i beleive the issue here is SQL server 2008 64 bit is not able to see the OLEDB registation... I'm trying to import data from Access 2003 database to SQL server 2008 64 bit version. I can run package from DTExecUI and it works fine. So i created job and selected SQL Server Integration Service Package as type and got the package from teh sql server. When i execute job it fails with above error.

ASKER CERTIFIED SOLUTION

Reza Rad

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Anandhi1

ASKER

Thank you for your suggestion. I checked the server where the access database is located. It did not have sql domain account in Administrator group. I added and executed the job and it successfully completed.

Thank you so much for your help!