SQL Server Agent Error - SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR.

• Friday, June 01, 2012 5:00 PM

   

   
  

  0

  Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted

  06/01/2012 04:30:00,OIA Caps Reports by CTR - Loc,Error,0,DBSG4431,OIA Caps Reports by CTR - Loc,(Job outcome),,The job failed.  The Job was invoked by Schedule 73 (Monthly - 1st).  The last step to run was step 1 (OIA Caps Reports by CTR).,00:00:02,0,0,,,,0

  06/01/2012 04:30:00,OIA Caps Reports by CTR - Loc,Error,1,DBSG4431,OIA Caps Reports by CTR - Loc,OIA Caps Reports by CTR,,Executed as user: OIARAD\sqlagent.
  Microsoft (R) SQL Server Execute Package Utility  Version 10.0.1600.22 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.   

  Started:  4:30:00 AM  Error: 2012-06-01 04:30:02.08     Code: 0xC0209303    
  Source: Package Connection manager "\\xxxxxx\d$\Reporting\PortalExamsReviewed_Location.xlsx"
     
  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: 2012-06-01 04:30:02.08     Code: 0xC020801C    
  Source: Data Flow - Load Orders in Spreadsheet OLE DB Destination [200]    
  Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "\\W23pap03\d$\Reporting\PortalExamsReviewed_Location.xlsx" 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: 2012-06-01 04:30:02.08     Code: 0xC0047017  
   
  Source: Data Flow - Load Orders in Spreadsheet SSIS.Pipeline     Description: component "OLE DB Destination" (200) failed validation and returned error code 0xC020801C.  End Error  Error: 2012-06-01 04:30:02.08     Code: 0xC004700C     Source: Data Flow - Load Orders in Spreadsheet SSIS.Pipeline     Description: One or more component failed validation.  End Error  Error: 2012-06-01 04:30:02.08     Code: 0xC0024107     Source: Data Flow - Load Orders in Spreadsheet      Description: There were errors during task validation.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  4:30:00 AM  Finished: 4:30:02 AM  Elapsed:  1.953 seconds.  The package execution failed.  The step failed.,00:00:02,0,0,,,,0

  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: 2012-06-01 04:30:02.08     Code: 0xC020801C    
  Source: Data Flow - Load Orders in Spreadsheet OLE DB Destination [200]    
  Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "\\xxxxxxx\d$\Reporting\PortalExamsReviewed_Location.xlsx" 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: 2012-06-01 04:30:02.08     Code: 0xC0047017  
   
  Source: Data Flow - Load Orders in Spreadsheet SSIS.Pipeline     Description: component "OLE DB Destination" (200) failed validation and returned error code 0xC020801C.  End Error  Error: 2012-06-01 04:30:02.08     Code: 0xC004700C     Source: Data Flow - Load Orders in Spreadsheet SSIS.Pipeline     Description: One or more component failed validation.  End Error  Error: 2012-06-01 04:30:02.08     Code: 0xC0024107     Source: Data Flow - Load Orders in Spreadsheet      Description: There were errors during task validation.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  4:30:00 AM  Finished: 4:30:02 AM  Elapsed:  1.953 seconds.  The package execution failed.  The step failed.,00:00:02,0,0,,,,0

  
  

  • Edited by Angel1953 Friday, June 01, 2012 5:01 PM
  •  
  • Reply
  • Quote