HTTP Connection Manager in SSIS

An HTTP connection enables a package to access a Web server by using HTTP to send or receive files. The Web Service task that SQL Server Integration Services includes uses this connection manager. When we add an HTTP connection manager to a package, Integration Services creates a connection manager that will resolve to an HTTP connection at run time, sets the connection manager properties, and adds the connection manager to the Connections collection on the package.

To creating the HTTP connection manager we need to right click on the package and click on the new connection.

                           

Click on Add.

HTTP connection manager editor will be open.

Here I am using Server URL is:

https://sites.google.com/site/ssisblogspot/products.csv

For the testing and click on the Test connection.

Time-out (in seconds): Provide a time-out for connecting to the Web server. The default value of this property is 30 seconds.

Chunk size (in KB): Provide a chunk size for writing data.

If we are hitting private server we need to provide the user ID, password and domain name.

If we are using the proxy server then we need to set the proxy server setting

 Use proxy: Specify whether you want the HTTP Connection Manager to connect through a proxy server.

Proxy URL: Type the URL for the proxy server.

Bypass proxy on local: Specify whether you want the HTTP Connection Manager to bypass the proxy server for local addresses.

Use credentials: Specify whether you want the HTTP Connection Manager to use security credentials for the proxy server.

User name: If the HTTP Connection Manager uses credentials, you must specify a user name, password, and domain.

Password: If the HTTP Connection Manager uses credentials, you must specify a user name, password, and domain.

Domain: If the HTTP Connection Manager uses credentials, you must specify a user name, password, and domain.

Proxy bypass list: the list of addresses for which you want to bypass the proxy server.

We can use this connection in the script task or web services task.