Azure Blob Download Task
Applies to: 
SQL Server
SSIS Integration Runtime in Azure Data Factory
The Azure Blob Download Task enables an SSIS package to download files from Azure Blob Storage.
To add an Azure Blob Download Task, drag-drop it to the SSIS Designer, and double-click or right-click and click Edit to see the following Azure Blob Download Task Editor dialog box.
The Azure Blob Download Task is a component of the SQL Server Integration Services (SSIS) Feature Pack for Azure.
The following table provides description for the fields in this dialog box.
| Field | Description |
|---|---|
| AzureStorageConnection | Specify an existing Azure Storage Connection Manager or create a new one that refers to an Azure Storage Account, which points to where the blob files are hosted. |
| BlobContainer | Specifies the name of the blob container that contains the blob files to be downloaded. |
| BlobDirectory | Specifies the blob directory that contains the blob files to be downloaded. The blob directory is a virtual hierarchical structure. |
| SearchRecursively | Specifies whether to search recursively within sub-directories. |
| LocalDirectory | Specifies the local directory where the downloaded blob files are stored. |
| FileName | Specifies a name filter to select files with the specified name pattern. For example, MySheet*.xls\* includes files such as MySheet001.xls and MySheetABC.xlsx. |
| TimeRangeFrom/TimeRangeTo | Specifies a time range filter. Files modified after TimeRangeFrom and before TimeRangeTo are included. |