Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR Expand / Collapse
Author
Message
Posted Wednesday, June 5, 2013 1:24 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 23, 2014 8:37 AM
Points: 7, Visits: 36
Incident Description: I can execute an SSIS package with no error using the SQL Execute Package Utility.

However, when I schedule a job to run the package I get the error below. I tried running it as 32bit but got the same error. I'm running Enterprise 2008 R2. I have a feeling I'm missing an easy fix but I just don't see it. I've deleted and recreated the package to rule out corruption. ?????? Any help is greatly appreciated.



Date 6/5/2013 12:20:44 PM
Log Job History (GEC Data Exporter)

Step ID 2
Server NGDATA
Job Name GEC Data Exporter
Step Name Step #2 SSIS Package to export data
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: W0112DOMAINgadmin. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 12:20:44 PM Error: 2013-06-05 12:20:44.44 Code: 0xC0209303 Source: GEC Analysis Data YTD 2013 Connection manager "DestinationConnectionOLEDB" Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The requested OLE DB provider Microsoft.ACE.OLEDB.12.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: 2013-06-05 12:20:44.44 Code: 0xC020801C Source: Data Flow Task 1 Destination - GECExport [82] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "DestinationConnectionOLEDB" 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: 2013-06-05 12:20:44.44 Code: 0xC0047017 Source: Data Flow Task 1 SSIS.Pipeline Description: component "Destination - GECExport" (82) failed validation and returned error code 0xC020801C. End Error Error: 2013-06-05 12:20:44.44 Code: 0xC004700C Source: Data Flow Task 1 SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2013-06-05 12:20:44.44 Code: 0xC0024107 Source: Data Flow Task 1 Description: There were errors during task validation. End Error DTExec: The package validation returned DTSER_FAILURE (1). Started: 12:20:44 PM Finished: 12:20:44 PM Elapsed: 0.234 seconds. The package execution failed. The step failed.

Post #1460410
Posted Wednesday, June 5, 2013 3:26 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 9:00 AM
Points: 488, Visits: 1,856
gsmith 7350 (6/5/2013)
Incident Description: I can execute an SSIS package with no error using the SQL Execute Package Utility.

....

Error: 2013-06-05 12:20:44.44 Code: 0xC0209303 Source: GEC Analysis Data YTD 2013 Connection manager "DestinationConnectionOLEDB" Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered -- perhaps no 64-bit provider is available.


It sounds like you might not have the ACE OLEDB 12 driver installed. The following article by Koen Verbeeck may be helpful. Be careful--there are a lot of considerations to the installation of this driver. The article gives a great overview. The comments discuss some of the further issues. Other articles are available with some searching. I've found the following one to be helpful: MSDN Social: HOW TO: FIX ERROR - "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine. It may or may not be helpful for your situation.
Post #1460460
Posted Thursday, June 6, 2013 4:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 23, 2014 8:37 AM
Points: 7, Visits: 36
MANY THANKS!

That's just what I needed. Works perfectly now.
Post #1460610
Posted Thursday, June 6, 2013 8:26 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 9:00 AM
Points: 488, Visits: 1,856
gsmith 7350 (6/6/2013)
MANY THANKS!

That's just what I needed. Works perfectly now.


Glad you got it working.
Post #1460720
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse