Error when SQL Server agent job is running

-1

I am trying to schedule a job to run a simple piece of code and export it to excel. I keep getting the following error message though. Is there something I'm missing? I am not sure what these error messages mean? Thanks.

Started:  12:19:52 PM  
Error: 2019-11-26 12:19:53.14     
Code: 0xC0209303     
Source: TEST Connection manager "DestinationConnectionExcel"     
Description: The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered. If the 64-bit driver is not installed<c/> run the package in 32-bit mode. 
Error code: 0x00000000.  An OLE DB record is available.  
Source: "Microsoft OLE DB Service Components"  
Hresult: 0x80040154  
Description: "Class not registered".  End Error  
Error: 2019-11-26 12:19:53.14     
Code: 0xC00291EC     
Source: Preparation SQL Task 1 Execute SQL Task     
Description: Failed to acquire connection "DestinationConnectionExcel". Connection may not be configured correctly or you may not have the right permissions on this connection.  End Error
DTExec: The package execution returned DTSER_FAILURE (1).  
Started:  12:19:52 PM  
Finished: 12:19:53 PM  
Elapsed:  0.547 seconds.  The package execution failed.  The step failed.,00:00:01,0,0,,,,0
sql-server
asked on Stack Overflow Nov 26, 2019 by Sm85 • edited Nov 26, 2019 by marc_s

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0