How to make an HTTP request from SSIS?

by

You can make use of the namespace System.Net.WebClient to make the Http request with the help of Script Task in SSIS. Following example shows how this can be achieved. The example was created in SSIS 2008 R2.

Step-by-step process:

  1. Create a new SSIS package and create two variables namely RemoteUri and LocalFolder. Set the variable RemoteUri with the value http://www.google.com/intl/en_com/images/srpr/logo1w.png. this is the image url of the logo on the Google’s home page. Set the variable LocalFolder with the value C:\temp\. this is the path where we are going to save the content. Refer screenshot #1.

  2. On the SSIS package, place a Script Task. Replace the Main() method within the script task with the code provided under the Script Task Code section. Refer screenshot #2.

  3. Screenshot #3 shows that the path C:\temp\ is empty.

  4. Screenshot #4 shows successful execution of the package.

  5. Screenshot #5 shows that the content (in this case the logo image) has been downloaded to the local folder path.

  6. Screenshot #6 shows that the code was tested to download a .zip file. To achieve this, the value of the variable RemoteUri was changed with the content url that needs to be downloaded.

Script task code:

C# code that can be used only in SSIS 2008 and above.

public void Main()
{
    Variables varCollection = null;

    Dts.VariableDispenser.LockForRead("User::RemoteUri");
    Dts.VariableDispenser.LockForRead("User::LocalFolder");
    Dts.VariableDispenser.GetVariables(ref varCollection);

    System.Net.WebClient myWebClient = new System.Net.WebClient();
    string webResource = varCollection["User::RemoteUri"].Value.ToString();
    string fileName = varCollection["User::LocalFolder"].Value.ToString() + webResource.Substring(webResource.LastIndexOf("https://stackoverflow.com/") + 1);
    myWebClient.DownloadFile(webResource, fileName);

    Dts.TaskResult = (int)ScriptResults.Success;
}

Screenshot #1:

1

Screenshot #2:

2

Screenshot #3:

3

Screenshot #4:

4

Screenshot #5:

5

Screenshot #6:

6

More Related Contents:

  1. What is the difference between a URI, a URL and a URN?
  2. Can I read the hash portion of the URL on my server-side application (PHP, Ruby, Python, etc.)?
  3. Are the PUT, DELETE, HEAD, etc methods available in most web browsers?
  4. Is an entity body allowed for an HTTP DELETE request?
  5. Are HTTP headers case-sensitive?
  6. How to display the Authentication Challenge in UIWebView?
  7. Difference between Pragma and Cache-Control headers?
  8. How to catch exception correctly from http.request()?
  9. Why both no-cache and no-store should be used in HTTP response?
  10. Which HTTP methods match up to which CRUD methods?
  11. Why is Cache-Control attribute sent in request header (client to server)?
  12. How to forward headers on HTTP redirect
  13. What’s the difference between HTTP 301 and 308 status codes?
  14. What HTTP status response code should I use if the request is missing a required parameter?
  15. What is the difference between HTTP and REST?
  16. Location detecting techniques for IP addresses
  17. Standard for adding multiple values of a single HTTP Header to a request or response
  18. How to point to localhost:8000 with the Dart http package in Flutter?
  19. Setting HTTP headers
  20. I need two instances of AngularJS $http service or what?
  21. HTTP and HTTPS iframe
  22. How to use Chrome’s network debugger with redirects
  23. What’s the difference between http://*:80 and http://+:80
  24. Should I use PATCH or PUT in my REST API?
  25. Is an HTTP PUT request required to include a body?
  26. http download file name
  27. how can an application use port 80/HTTP without conflicting with browsers?
  28. Can a http server detect that a client has cancelled their request?
  29. Should cookie values be URL encoded?
  30. How does url rewrite works?

Leave a Comment