Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server
SSIS Integration Runtime in Azure Data Factory
The Azure Blob Upload Task enables an SSIS package to upload files to Azure Blob Storage.
To add an Azure Blob Upload Task, drag-drop it to the SSIS Designer, and double-click or right-click and click Edit to see the following Azure Blob Upload Task Editor dialog box.
The Azure Blob Upload Task is a component of the SQL Server Integration Services (SSIS) Feature Pack for Azure.
The following table provides descriptions 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 uploaded files as blobs. |
BlobDirectory | Specifies the blob directory where the uploaded file is stored as a block blob. The blob directory is a virtual hierarchical structure. If the blob already exists, it is replaced. |
LocalDirectory | Specify the local directory that contains the files to be uploaded. |
SearchRecursively | Specify whether to search recursively within sub-directories. |
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. |
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Upload images to Azure Blob Storage from a static web app - Training
Learn how to securely upload images to Azure Blob Storage from a static web app by using an Azure Function to generate on demand shared access signatures.
Certification
Microsoft Certified: Azure Data Engineer Associate - Certifications
Demonstrate understanding of common data engineering tasks to implement and manage data engineering workloads on Microsoft Azure, using a number of Azure services.
Documentation
Azure Blob Source - SQL Server Integration Services (SSIS)
Azure Blob Source
Flexible File Task - SQL Server Integration Services (SSIS)
Flexible File Task
Azure Blob Download Task - SQL Server Integration Services (SSIS)
Azure Blob Download Task