Our SSIS package randomly fails with the following error message:
An exception has occurred during data insertion, the message returned from the provider is: WriteToServer requires an open and available Connection. The connection's current state is closed.
Every time it's a different step, sometimes the package runs w/o any issue for a few days in a row, but then suddenly fails. There were no changes introduced in the package itself nor to SQL Server configuration. The only thing which might change is basically the amount of data, it gradually increases. We are running Integration Services in SQL Server 2016 (it's installed on the same machine along with SQL Server). There is nothing suspicious on the SQL Server side, when the SSIS failure occurs the other apps are connecting to SQL Server with no issues, the SQL error log is empty.
Has anyone spotted anything similar? Any tips on how to troubleshoot this? I am not a big fan or expert in SSIS :) so I really count on your expertise!