SSIS Download File Task

Step-By-Step

In this tutorial we will learn how to Download file from Internet URL using ZS Download File Task.

Firstly, You need to Download and Install SSIS ZappySys PowerPack.

Once you finished first step, Open Visual Studio and Create New SSIS Package Project.

Now, In the Visual Studio drag and drop ZS Download File Task from SSIS Toolbox in the design surface.
SSIS Download File Task - Drag and Drop

Here, we are going through Dynamic URL.

We need to create Variable for Source URL and File Connection for Target Path.

How to Create Variable and File Connection.

Let's Create Variables, In Visual Studio Right Click on Design Panel, Select Variables.
SFTP Task Operations - Create Variable

Here, If you want to download files from Local or Server Source use following format URL.

c:\data\file123.txt (Local file Source Path)
https://s3.amazonaws.com/nyc-tlc/trip+data/fhv_tripdata_2015-01.csv (Server file Source URL)

Now, Right click on Connection Managers Panel to Create File Connection, so you can use Source or Destination Path, and Context Menu will appear, Select New Connection from the Context Menu.
SSIS Download File Task - Connection

Click on OK button to save configure setting UI.

How to download file using Download File Task.

Double click on Download File Task for Configure it.

Set URL Access mode to Variable and select Variable we have created before for Source URL. Set Target Path to Connection and select connection. Check on Overwrite target file if exists.
SSIS Download File Task - Configure

Click on OK button to save configure setting UI.

Thats all, You can run or execute and wait until success.
SSIS Download File Task - Execute

Properties

Property Name

Description

Connection

Specifies URL connection from where you want to download. You can also specify proxy settings on this connection manager.

UrlAccessMode

AccessMode for URL

Available Options (Use numeric value listed in bracket if you have to define expression on this property (for dynamic behavior).

Option	Description
Direct [0]	Direct
Variable [1]	Variable
Connection [2]	Connection

Url

URL from which you want to download file.

UrlVariable

Variable which holds file URL

TargetFileAccessMode

AccessMode for target file

Available Options (Use numeric value listed in bracket if you have to define expression on this property (for dynamic behavior).

Option	Description
Direct [0]	Direct
Variable [1]	Variable
Connection [2]	Connection

TargetFilePath

Specifies target file path where you want to save downloaded file.

TargetFileVariable

Target file path variable

TargetFileConnection

Target file connection

OverwriteTarget

Specifies whether you want to overwrite target file if already exists.

LoggingMode

Available Options (Use numeric value listed in bracket if you have to define expression on this property (for dynamic behavior).

Option	Description
Normal [0]	Normal
Medium [1]	Medium
Detailed [2]	Detailed
Debugging [3]	Debugging

PrefixTimestamp

When you enable this property it will prefix timestamp before Log messages.

Introduction In this post we will see how to download file from URL using SSIS REST API Task. If you want to call REST API rather than download file then check this article. Basically you can download file from URL using two different tasks. SSIS Download File Task offers simple way to download file without […]

Content

Video Tutorial

Step-By-Step

How to Create Variable and File Connection.

How to download file using Download File Task.

Properties

Setting UI

See Also

Articles / Tutorials

How to download file from URL using SSIS