Good Afternoon,
1) I run a SSIS Package (.dtsx) in Visual Studio and it gives following error (it failed populating an Excel file):
[Connection manager "EVIDENCE EXPORT"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft Access Database Engine" Hresult: 0x80004005 Description: "External table is not in the expected format.".
2. Without making any changes I executed again, and it ran perfect.
The SQL Agent Job from which this SSIS package (.dtsx) runs consistently fails. The package is in fact stored on the Integration Services Catalog in SSMS.
I am hoping that if I can resolve the intermittent failing in Visual Studio, this will resolve the consistent failure in the SQL Agent Job.
SQL Server version: Microsoft SQL Server 2016 (SP2-CU8) (KB4505830)
Excel version: Microsoft Office Professonal Plus 2016
Kindly advise what is going on.