SSIS traffic to the internet can be routed via a proxy, and it is possible to manage this scenario both by configuration and through code in the script component. For an SSIS package that requires accessing a web resource via a proxy, you can use .NET code within the script component to set up the necessary web proxy settings. By leveraging the System.Net.WebProxy
class in your script component, you can programmatically define the proxy server details and assign it to the web request:
WebProxy proxy = new WebProxy("http://proxyserver:port", true);
proxy.Credentials = CredentialCache.DefaultCredentials;
WebRequest request = WebRequest.Create("http://url");
request.Proxy = proxy;
This allows you to control the routing of that specific web request through the specified proxy. Also in a deployed environment, you may find specific .config files where similar proxy settings can be applied, depending on the version and setup of SSIS.