dotConnect for salesforce using SSIS fails for TLS 1.1 or higher

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Cloud Applications
Post Reply
raghav
Posts: 1
Joined: Wed 06 Apr 2016 19:17

dotConnect for salesforce using SSIS fails for TLS 1.1 or higher

Post by raghav » Wed 06 Apr 2016 19:20

Hello I was trying to connect salesforce using dotconnect for SSIS and it throws an error that Please use TLS 1.1 or higher when connecting to Salesforce. Any help is much appreciated

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: dotConnect for salesforce using SSIS fails for TLS 1.1 or higher

Post by Shalex » Thu 07 Apr 2016 09:00

The behaviour is changed: usage of TLS 1.0 is no longer hardcoded in the provider, now the necessary TLS version can be specified by user.

Please upgrade to the newest build. After this, there are two alternative ways to switch package to using TLS 1.1:
1) change the registry on the workstation where you are running your SSIS package like described at https://help.salesforce.com/apex/HTView ... =000221207 > the .NET section
2) set System.Net.ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls11; via Script Task: https://www.simple-talk.com/sql/ssis/ad ... -packages/

If this doesn't help, please specify:
a) the name of the product you are using ("dotConnect for Salesforce Professional" or "SSIS Data Flow Components for Salesforce")
b) the product version (x.x.x). You can check this via right click the installation > Properties > Details
c) have you tried both alternative ways (1 and 2) of setting TLS 1.1?

Post Reply