SSIS TO SALESFORCE Could not establish trust relationship for the SSL/TLS secure channel

Billy Blue 1 Reputation point
2022-09-01T09:51:36.32+00:00

Using the Salesforce source connector in SSIS supplied by Cozyroc in Visual Studio 2019. This was working perfectly until a week ago and then started getting the following error:

Error: System.Net.WebException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel

I have contacted both Cozyroc and Salesforce who have directed me to contact Microsoft.

Any help would be appreciated.

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,769 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,488 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,581 Reputation points
    2022-09-02T03:13:08.7+00:00

    Hi @Billy Blue ,

    The issue might be that:

    You're using an invalid certificate:

    The certificate wasn't issued by a trustworthy authority.

    Try to navigate to the service URL using a browser and have a check.

    Here is a same thread you may take a reference to : https://social.technet.microsoft.com/Forums/msonline/en-US/f9aee5bb-d307-4782-9633-adc29fd10189/ssisssdt-the-underlying-connection-was-closed?forum=sqlintegrationservices

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.