I have ssis packages made in Microsoft vs2008, for generating reports in excel formats. For excel connection manager version excel version used is 'Microsoft Excel 97-2003. Till day before yesterday it was working fine. But from yesterday it was throwing error for excel version. But when I changed version to ' Microsoft Excel 2007'. It works fine. -No update in excel -No update in vs2008. - running package using SQL server agent
Thanks in advance.
It looks like that one of the latest Windows Security updates broke the Excel/Jet driver. Workaround would be to uninstall one of the following (KB 4040685,KB 4041693, KB 4041687) and reboot the server
User contributions licensed under CC BY-SA 3.0