This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

TaskFactory | Sharepoint Documents task started failing 8/27/2022


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.

Thank you.