SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR


SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR

Author
Message
gsmith 7350
gsmith 7350
SSC Rookie
SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)

Group: General Forum Members
Points: 25 Visits: 45
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.
kl25
kl25
Say Hey Kid
Say Hey Kid (688 reputation)Say Hey Kid (688 reputation)Say Hey Kid (688 reputation)Say Hey Kid (688 reputation)Say Hey Kid (688 reputation)Say Hey Kid (688 reputation)Say Hey Kid (688 reputation)Say Hey Kid (688 reputation)

Group: General Forum Members
Points: 688 Visits: 1875
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.
gsmith 7350
gsmith 7350
SSC Rookie
SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)

Group: General Forum Members
Points: 25 Visits: 45
MANY THANKS!

That's just what I needed. Works perfectly now. :-D
kl25
kl25
Say Hey Kid
Say Hey Kid (688 reputation)Say Hey Kid (688 reputation)Say Hey Kid (688 reputation)Say Hey Kid (688 reputation)Say Hey Kid (688 reputation)Say Hey Kid (688 reputation)Say Hey Kid (688 reputation)Say Hey Kid (688 reputation)

Group: General Forum Members
Points: 688 Visits: 1875
gsmith 7350 (6/6/2013)
MANY THANKS!

That's just what I needed. Works perfectly now. :-D


Glad you got it working. :-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search