Excel connection manager failed with error code 0xC0202009

-1

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.

ssis
ssis-2008
asked on Stack Overflow Oct 31, 2017 by user8456080

1 Answer

0

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

answered on Stack Overflow Nov 13, 2017 by Athu

User contributions licensed under CC BY-SA 3.0