vprunic (8/22/2016)
When i add it to a project it works fine when its executed in 32 bitBut when I start it SQL server
Code: 0xC0209303
Source: TransferMappings 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, 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".
Are you running this as an SQL job? If so you need to check the "run as 32 bit runtime" option i mentioned in my post earlier. Go to job properties, steps and go to execution options.
I can't see any other possible solution. The fact it runs as a project in 32bit this would be the solution