SSIS Connection to Sales Force sandbox

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Cloud Applications
Post Reply
sportrx123
Posts: 6
Joined: Tue 17 Feb 2015 18:19

SSIS Connection to Sales Force sandbox

Post by sportrx123 » Tue 17 Feb 2015 18:27

Hi there.
I was being able to connect to Sales Force website using ssis and devard dotnetConnector.

I have another login/password and security token to connect to the sandbox but it failed.
My questions are:
1 do I need any additioanal info (such as proxy server)?
2. How does devart know which site (Sf or sandbox) to connect to?

brucecallen
Posts: 6
Joined: Tue 17 Feb 2015 20:31

Re: SSIS Connection to Sales Force sandbox

Post by brucecallen » Tue 17 Feb 2015 21:05

You need to change your connection string for the sandbox:
Find the part of the connection string that has: Host=login.salesforce.com
Change this to Host=test.salesforce.com for the sandbox.

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

Re: SSIS Connection to Sales Force sandbox

Post by Shalex » Wed 18 Feb 2015 17:59

@brucecallen
Thank you for your help.

@sportrx123
Please confirm that the issue is solved.

sportrx123
Posts: 6
Joined: Tue 17 Feb 2015 18:19

Re: SSIS Connection to Sales Force sandbox

Post by sportrx123 » Thu 09 Apr 2015 16:37

Sorry for late response.
The issue was solved.

Post Reply