June 5, 2013 at 1:24 pm
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.
Date6/5/2013 12:20:44 PM
LogJob History (GEC Data Exporter)
Step ID2
ServerNGDATA
Job NameGEC Data Exporter
Step NameStep #2 SSIS Package to export data
Duration00:00:00
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
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.
June 5, 2013 at 3:26 pm
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[/url] 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[/url]. It may or may not be helpful for your situation.
June 6, 2013 at 4:36 am
MANY THANKS!
That's just what I needed. Works perfectly now. 😀
June 6, 2013 at 8:26 am
gsmith 7350 (6/6/2013)
MANY THANKS!That's just what I needed. Works perfectly now. 😀
Glad you got it working. 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply