we export data into Excel file from SQL Server 2017 with a simple command (a part of a stored procedure):
The command looks like:
INSERT INTO OPENDATASOURCE('Microsoft.ACE.OLEDB.16.0', 'Excel8.0;HDR=YES;IMEX=1;Database=\\some_folder\excel1.xls')...Sheet1
SELECT * FROM table1
It works fine. But only if just one export is processing at the same time.
If more exports are processing simultaneously, the exports crashes, an exception is raised.
"SqlDumpExceptionHandler: Process 68 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
One process is terminated, the other ones are hanging and no other export is possible to start, unless restarting the sql server service.
We are not sure, is it a problem of OLEDB driver or of SQL server service?
Thank you for any advice,