July 6, 2010 at 8:01 am
Hi when i run the package in sql server agent. im getting error.. when i run mannually im not getting any error. The error is
SQL Server Execute Package Utility Version 10.0.2531.0 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 7:45:00 AM Error: 2010-07-06 07:45:03.76 Code: 0xC0209302 Source: PAFormsCreation Connection manager "Excel Connection Manager" Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR. The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. 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-07-06 07:45:03.77 Code: 0xC020801C Source: Web-Retail to Print Shop Excel Destination [66] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0209302. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2010-07-06 07:45:03.77 Code: 0xC0047017 Source: Web-Retail to Print Shop SSIS.Pipeline Description: component "Excel Destination" (66) failed validation and returned error code 0xC020801C. End Error Error: 2010-07-06 07:45:03.77 Code: 0xC004700C Source: Web-Retail to Print Shop SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2010-07-06 07:45:03.79 Code: 0xC0024107 Source: Web-Retail to Print Shop Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 7:45:00 AM Finished: 7:45:03 AM Elapsed: 3.469 seconds. The package execution failed. The step failed.
July 6, 2010 at 2:19 pm
I see a couple of things to look at here:
The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered.
Make sure the provider is at the same version on all devices
Excel Destination" (66) failed validation and returned error code
Is the destination properly set up on the server where the job is running?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply