{"id":2508,"date":"2018-01-24T04:08:57","date_gmt":"2018-01-24T04:08:57","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=2508"},"modified":"2026-02-12T22:27:01","modified_gmt":"2026-02-12T22:27:01","slug":"download-file-url-using-ssis","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/download-file-url-using-ssis\/","title":{"rendered":"How to download file from URL using SSIS"},"content":{"rendered":"

Introduction<\/h2>\n

In this post, we will see how to download a file from a URL using the\u00a0SSIS REST API Task<\/a>. If you want to call the REST API instead of downloading a file, check this article<\/a>.<\/p>\n

Basically, you can download a file from a URL using two different tasks.<\/p>\n

\n\n\n\n\n
\"Custom<\/td>\n\u00a0SSIS Download File Task<\/a><\/td>\n<\/tr>\n
\"Custom<\/td>\n\u00a0SSIS REST API Task<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

SSIS Download File Task<\/strong> offers a simple way to download a file without advanced settings (e.g. Specify OAuth Credentials, Headers, Body, Content Type, etc)<\/p>\n

The SSIS REST API Task<\/strong> offers a much more robust way to download, including specifying OAuth credentials, Basic Credentials, Headers, Body, changing the SSL\/TLS Protocol version, specifying a Proxy, and setting Error Retry Settings, etc.<\/span><\/p>\n

Prerequisites<\/span><\/h2>\n

Before we download a file from a URL using SSIS, you will need to make sure the following prerequisites are met.<\/p>\n

    \n
  1. SSIS designer installed. Sometimes it is referred to as BIDS or SSDT (download it from the Microsoft site<\/a>).<\/li>\n
  2. Basic knowledge of SSIS package\u00a0development using\u00a0Microsoft SQL Server Integration Services<\/em>.<\/li>\n
  3. Make sure\u00a0SSIS PowerPack<\/em><\/a>\u00a0is installed.\u00a0Click here to download<\/a>.<\/li>\n<\/ol>\n

    Method-1 (Preferred): Download file from URL using REST API Task<\/h2>\n

    Download from Public Page (No Login required)<\/h3>\n
      \n
    1. Create a new SSIS Package and open the designer<\/li>\n
    2. Drag\u00a0ZS REST API Task<\/a>\u00a0from SSIS Toolbox (Control Flow)<\/li>\n
    3. Double-click it to edit<\/li>\n
    4. Enter the following URL<\/strong>\n
      https:\/\/zappysys.com\/downloads\/files\/nw.zip<\/pre>\n
      \"\"<\/a>
      SSIS REST API Task – Download File from URL (Request Settings)<\/p><\/div>\n
      <\/div>\n<\/li>\n
    5. Now go to the Response Settings<\/strong> Tab<\/li>\n
    6. Check the Save Response Content<\/strong> option<\/li>\n
    7. Select Save Mode = Save to file<\/li>\n
    8. Specify target file path (e.g., c:\\ssis\\nw.zip )<\/li>\n
    9. Check\u00a0the Treat response as a binary<\/strong> option. This option must be checked if the file is binary format (e.g., image, mp3, avi, zip)\n
      <\/div>\n
    10. Click OK to save and Execute SSIS Package.<\/li>\n<\/ol>\n
      Using Credentials to download from Secure Page<\/h3>\n
      There will be a time when you have to download from a secure page which requires some sort of Authentication information. REST API Task Support Download URL From Connection option.\u00a0 You can use HTTP Connection<\/a> or OAuth Connection<\/a><\/p>\n
      \"\"<\/a>
      Using HTTP Connection in SSIS REST API Task to Download Files or Other Data<\/p><\/div>\n
      Method-2: Download file from URL using Download File Task<\/h2>\n
        \n
      1. Create new SSIS Package and open designer<\/li>\n
      2. Drag\u00a0ZS Download File Task<\/a>\u00a0from SSIS Toolbox (Control Flow)<\/li>\n
      3. Double click it to edit<\/li>\n
      4. Change Url Access Mode to Direct<\/strong><\/li>\n
      5. Enter the following URL\n
        https:\/\/zappysys.com\/downloads\/files\/nw.zip<\/pre>\n<\/li>\n
      6. In the target set target file path (e.g. c:\\ssis\\nw.zip )<\/li>\n
      7. Click OK to save and Execute SSIS Package.\n
        \"\"<\/a>
        SSIS Download File Task – Download File from URL<\/p><\/div><\/li>\n<\/ol>\n
        Advanced Scenarios (Data Flow)<\/h2>\n
        In addition to downloading files in Control Flow using the REST API Task or Download File Task, you can now also download binary files (PDF, image, ZIP, etc.) dynamically inside SSIS Data Flow using the Web API Destination component.
        \nFor a detailed step-by-step tutorial that shows how to handle binary responses and write them to disk per row in Data Flow, check out this community article:
        \n\ud83d\udc49 How to Download Binary File (PDF, Image, ZIP) from URL in SSIS Data Flow using Web API Destination \u2014         click here<\/a><\/p>\n