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
User contributions licensed under CC BY-SA 3.0