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
Job Name GEC Data Exporter
Step Name Step #2 SSIS Package to export data
Sql Severity 0
Sql Message ID 0
Operator Net sent
Retries Attempted 0
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  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.