Included in SSIS PowerPack

SSIS Download File Task

Download a file from any URL in an SSIS package, using a direct URL, a variable or a connection.

Download File Task is a free SSIS Control Flow task that downloads a file from any internet or intranet URL over HTTP or HTTPS. Supply the URL directly, from a variable or from a connection (with proxy settings), choose the target path the same way, and decide whether to overwrite an existing file.

Download File Task is free in every edition. The same download also includes a trial of the paid PowerPack components

Download File Task in SSDT
SSIS Download File Task downloading a file from an internet URL
Download a file from an HTTP or HTTPS URL to a local fileExplore the UI →

Trusted by data teams worldwide

MicrosoftIBMOracleDell TechnologiesHPCiscoAT&TVerizonDHLFedExUPSWalmart

Also rated on Capterra★★★★★ , Trustpilot★★★★★ and BBBA+ — see why teams trust ZappySys

At a glance

What Download File Task can do

Download File Task downloads a file from any URL in an SSIS package. Supply the URL directly, from a variable or from a connection, and save it to a direct path, a variable or a file connection.

Download from any URL

Download a file from any URL in an SSIS package.

  • Internet or intranet over HTTP or HTTPS
  • Web URL (e.g. a CSV or ZIP file) or a local / server file path

Download file from URL guide

Three URL access modes

Supply the source URL directly, from a variable or from a connection.

  • UrlAccessMode: Direct, Variable or Connection
  • Url or UrlVariable

Task properties

Flexible target path

Choose where to save the downloaded file in the same three ways.

  • TargetFileAccessMode: Direct, Variable or Connection
  • TargetFilePath, TargetFileVariable, TargetFileConnection

Task properties

Proxy support

Specify proxy settings on the URL connection manager used for the download.

  • Connection property

Task properties

Overwrite control

Choose whether to overwrite the target file if it already exists.

  • OverwriteTarget

Task properties

Logging options

Control how much is logged while the task runs.

  • LoggingMode: Normal, Medium, Detailed or Debugging
  • PrefixTimestamp adds a timestamp to log messages

Task properties

Advanced download options

For OAuth or basic credentials, headers, body, SSL/TLS version or retry settings, use the REST API Task instead.

REST API Task

SQL Server 2012–2025 & ADF

Runs in your environment on SQL Server 2012–2025 and Azure-SSIS.

  • SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit)
  • Azure Data Factory (SSIS IR)
  • Design packages in Visual Studio 2017, 2019, 2022, or 2026
  • Windows only (64-bit OS): Windows 7–11 or Windows Server 2012–2025

Compatibility and requirements

See all features
  • Free component, included in every SSIS PowerPack edition
  • Download a file from any internet or intranet URL over HTTP or HTTPS
  • Direct URL, Variable or URL from Connection mode
  • Target file path set directly, from a variable or from a file connection
  • Proxy support via the URL connection manager
  • Option to overwrite the target file if it already exists
  • Make properties dynamic with SSIS expressions (numeric option values)
  • Logging modes (Normal, Medium, Detailed, Debugging) with optional timestamp prefix
  • Use the REST API Task for OAuth, headers, body or retry settings
  • Support for SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit) and Azure Data Factory

Runs in your environment ·

SQL Server 2012–2025

and Azure-SSIS · Read the FAQ

How it works

From the toolbox to your first run.

Key steps from the Download File Task page and help file, with the screens you will see in SSDT.

Download from a URL you type in.

Drag ZS Download File Task onto the Control Flow and double-click it. Set Url AccessMode to Direct, enter the URL, set the target Path (for example c:\ssis\myfile.zip) and choose whether to overwrite the target file if it exists.

  • Internet or intranet over HTTP or HTTPS
  • Proxy settings on the Proxy tab
Download File Task - Direct URL and target path

Inside the UI

Key settings, as they appear in SSDT.

Real screens from the Download File Task product page. Step through them, or open any shot at full size.

Direct URL mode

Enter the URL and target path directly, and choose whether to overwrite the target file.

Compatibility and requirements

Designed to stay inside your SSIS runtime.

  • SQL Server 2012 through 2025, 32-bit and 64-bit
  • Windows only, 64-bit OS required. SQL Server Express and Web editions do not include SSIS
  • Azure Data Factory SSIS Integration Runtime
  • Self-hosted: credentials and data stay in your environment (external API calls still reach that service)
  • Fully functional 30-day trial of SSIS PowerPack

FAQ

Questions teams ask before they drop Download File Task on the canvas.

What is Download File Task?

Download File Task is a free SSIS Control Flow task that downloads a file from any URL. You can supply the URL directly, from a variable or from a connection, save the file to a direct path, a variable or a file connection, use a proxy, and choose whether to overwrite an existing file.

Is Download File Task free?

Yes. It is included in the FREE edition of SSIS PowerPack, as well as in the Standard, Professional and Enterprise editions. See compare editions.

How do I download a file from a URL that changes at runtime?

Store the URL in an SSIS variable and set Url AccessMode to Variable. The target path can come from a variable or a File Connection in the same way. See How it works.

What if the download needs OAuth, headers or retries?

Download File Task is the simple option, without advanced settings such as OAuth credentials, headers or body. For those, plus SSL/TLS version and error retry settings, use the REST API Task with its save-response-to-file option. See how to download a file from a URL using SSIS.

Which SQL Server versions can I run it on?

SQL Server 2025, 2022, 2019, 2017, 2016, 2014, and 2012 (32- and 64-bit), plus Azure Data Factory with an SSIS Integration Runtime (packages must target SQL Server 2017). See Compatibility and requirements.

Independent ratings

Trusted by data teams, recognized by the industry

See why teams trust ZappySys (opens in new tab)

What customers say

  • Customer story

    ZappySys has been a fantastic way to bring our small company into the world of APIs, automation, and systems integration by providing tools within an easy-to-use framework.

    Ben KingeryOxspring Paul
  • Customer story

    At Synchronous Customers, we need to connect various types of data quickly. The super handy ZappySys connectors and great documentation let us do it without writing a lot of code.

    Joel ConnerSynchronous Customers
  • Customer story

    I looked everywhere for a product that could integrate to a web portal backend API via JSON. After many attempts, ZappySys was the only solution that gave me all the options I needed in a quick & clean interface within SSIS.

    Maz DunicSave the Children Australia
  • Customer story

    We have worked with the ZappySys support team for over a year and have consistently found them extremely helpful — resourceful and creative in offering multiple solutions to our challenges.

    Senthil SekarPublicis Groupe
  • Trustpilot

    I’ve been using ZappySys for over 6 years — it makes development faster, and I introduced it to my current company.

    Anna JohnsonTrustpilot review
  • Trustpilot

    I’m integrating data from APIs into database tables with SSIS/ZappySys — very easy to use, fast, and highly efficient without writing complex code.

    Carolyn S.Trustpilot review
  • Customer quote

    I submitted a support request and had someone logged in and fixing things within 2 hours.

    Barry Wilson
  • Customer quote

    The REST source is very powerful — the only thing I found I could use after trying components from major vendors.

    Jes KirkupKTC
  • Customer quote

    Whenever we run into an obstacle, ZappySys has a solution for us. We are so glad that we chose ZappySys PowerPack.

    Kevin ChenBerricle

Free in every edition

Install SSIS PowerPack and drag Download File Task onto the Control Flow.

Download a file from any URL in an SSIS package, using a direct URL, a variable or a connection.

  • Control Flow Task in SSISDownload File Task appears in the toolbox after you install PowerPack.
  • Free to useDownload File Task is included in the FREE edition of SSIS PowerPack.
  • Live supportQuestions? Talk to a ZappySys engineer.

Talk to an engineer before or during your trial.

1 / 8