November 24, 2016 at 1:37 am
Hi Guys,
I have built a ETL package using SQL Server 2014, it extracts from a Salesforce source going to SQL Server. The package has a script task as a source that makes a call to a Salesforce 'Bulk API'.
When I first tried running the package directly from SSDT (whilst being logged on the the remote server) I got the following error message: No connection could be made because the target machine actively refused it <ip address>, <port>. After we set the proxy on the same machine the package ran fine. I can run it successfully directly within SSDT or from msdb by right clicking the package and clicking 'Run Package'.
The problems start when I attempt to run the same package from a SQL Agent job on the same machine, I get the same error message above. It looks to me like the package isn't going to Salesforce via the proxy when I execute it from a SQL Agent job. I've been stuck on this for the past day with no success. Any suggestions?
November 24, 2016 at 6:37 am
It was a permissions issue with the service account that was being used to run the SQL Job. Because Salesforce is web based, the service account needed more permissions to go across the internet.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply