We have an SSIS job that uploads business-provided excel file to Sharepoint (online) that has been working fine for years until August 27th 2022 (around 7pm pacific, approximately).
The error is "An existing connection was forcibly closed by the remote host."
When I run the TaskFactory task from my local VisualStudio I get a different error "[ExecuteTask Failed:] Error: Could not connect to sharepoint server. Error was 'The remote server returned an error: (400) Bad Request.'"
I checked the Sharepoint site and list/folder and they are all there, and permissions are fine (the same). I also did the "Test Connection" on the SSIS connection manager and it says "Connection succeeded".
My TaskFactory version is 2021.18.1
Has anyone experienced similar issue? We think that Microsoft may have changed something on their end.