In our SQL Agent Data Warehouse load job, we are running into intermittent issues with connecting to our ODBC driver. We had run into this issue previously, but it essentially disappeared on its own; however, once I upgraded the SQL server's OS to Windows Server 2019 (Nov 22) we started to have issues with the connection to the driver again. It happens a few times a day (sometimes only once or twice, sometimes several times)
In the SQL server Event Viewer, there is a COMPLUS (Component +) error that reads as an ODBC issue (below):
Component Prog ID: 2[ODBC][Env 000000000F7E8150] Method Name: IDispenserDriver::CreateResource Process Name: ISServerExec.exe Exception: c0000005 Address: 0X00007FF8EA58E56BOn the SQL Job itself we're running into an ADO NET connection issue.
Or some sort of other issue finding connection (below)
