Can integration services (SSIS) traffic to the internet be routed via a proxy ?

Greg Booth 1,026 Reputation points
2022-11-01T12:06:39.64+00:00

We deploy integration services on a server.
We have a package that needs to be able to access a web resource ( a script component is grabbing some data from an API by calling out to a URL).
The server is currently only allowed to talk to talk to the internet via the firewall to resources with a fixed IP address - but the URL we want to use this time does not have a fixed IP address - and we want to route SSIS via the proxy. Is this possible ?

As we are using a script component, we could add lines of code to direct the traffic (for this script component) via the proxy ?

When developing the package we used Visual Studio, and had to add a section to the devenv. exe.config in c:\program files (x86)... visual studio... to force the traffic through the proxy (but maybe this is forcing the traffic through the users proxy ). We added a section to the config like

<system.net> <settings> <ipv6 enabled="true"/> <servicePointManager expect100Continue="false"/> </settings> <defaultProxy useDefaultCredentials="true" enabled="true"> <proxy usesystemdefault="True" /> </defaultProxy></system.net>

Is there a similar .config file for SSIS on the server where the package will be deployed too ?
Or can we force the traffic to use the proxy by adding lines of .net code to the script component to have the same affect ?

Kind regards

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,092 questions
0 comments No comments
{count} votes