We recently migrated our SSIS projects from Visual Studio 12 to Visual Studio 19.
I imported all of the projects successfully into the new server via Visual Studio 19
They all work fine with one exception. The SSIS packages that update data into an excel file all fail.
I was hoping it was a 64bit/32bit issue so I made sure they were set to 32-bit, but that did not help.
I am hoping you can point me in the right direction as I am on my own with this one.
I am guessing that perhaps the DBA did not include either the 32-bit or 64-bit drivers?
Here are the errors I get: (copied from the Progress tab):
- [Excel Destination [92]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager 3" failed with error code 0xC0209302. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
- [SSIS.Pipeline] Error: Excel Destination failed validation and returned error code 0xC020801C.
- [SSIS.Pipeline] Error: One or more component failed validation.
- [Connection manager "Excel Connection Manager 3"] Error: The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. If the 32-bit driver is not installed, run the package in 64-bit mode. Error code: 0x00000000.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
5.[Connection manager "Excel Connection Manager 3"] Error: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. For more information, see http://go.microsoft.com/fwlink/?LinkId=219816
Thanks in advance for your assistance! I am hoping you can point me in the right direction.