I created an Excel connection. When I create a data stream with the destination Excel and click "Excel Sheet Name", I get an "Unspecified Error". When I look in the "Show advanced editor" section of the recipient, I see the following error:
Error at blah [Connection manager "DestinationConnectionExcel"]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unspecified error". Error at Insert blah [Destination - blah [199]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "DestinationConnectionExcel" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap)
I read many other posts and nothing helps. I tried to set “DelayValidation = True” for the whole Jet Engine related task. Although this allows me to run the package without any errors, I cannot change or change anything. I also cannot create new tasks using Excel.
I already tried to set "Run64BitRuntime = false" and this also does not help.
Another note. The problem is intermittent. I was able to work with Excel tasks once after a reboot, and another time it all failed, as I described.
Any help would be greatly appreciated. Thank you all
source
share