Page 1 of 1

SSIS Connection to Sales Force sandbox

Posted: Tue 17 Feb 2015 18:27
by sportrx123
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?

Re: SSIS Connection to Sales Force sandbox

Posted: Tue 17 Feb 2015 21:05
by brucecallen
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.

Re: SSIS Connection to Sales Force sandbox

Posted: Wed 18 Feb 2015 17:59
by Shalex
@brucecallen
Thank you for your help.

@sportrx123
Please confirm that the issue is solved.

Re: SSIS Connection to Sales Force sandbox

Posted: Thu 09 Apr 2015 16:37
by sportrx123
Sorry for late response.
The issue was solved.