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 Flexible File Task enables users to perform file operations on various supported storage services. Currently supported storage services are
The Flexible File Task is a component of the SQL Server Integration Services (SSIS) Feature Pack for Azure.
To add a Flexible File Task to a package, drag it from SSIS Toolbox to the designer canvas. Then double-click the task, or right-click the task and select Edit, to open the Flexible File Task Editor dialog box.
The Operation property specifies the file operation to perform. Currently supported operations are:
For Copy operation, following properties are available.
*
(matches zero or more characters), ?
(matches zero or single character) and ^
(escape character).For Delete operation, following properties are available.
*
(matches zero or more characters), ?
(matches zero or single character) and ^
(escape character).Notes on Service Principal Permission Configuration
For Test Connection to work (either blob storage or Data Lake Storage Gen2), the service principal should be assigned at least Storage Blob Data Reader role to the storage account. This is done with RBAC.
For blob storage, read and write permissions are granted by assigning at least Storage Blob Data Reader and Storage Blob Data Contributor roles, respectively.
For Data Lake Storage Gen2, permission is determined by both RBAC and ACLs. Pay attention that ACLs are configured using the Object ID (OID) of the service principal for the app registration as detailed here. This is different from the Application (client) ID that is used with RBAC configuration. When a security principal is granted RBAC data permissions through a built-in role, or through a custom role, these permissions are evaluated first upon authorization of a request. If the requested operation is authorized by the security principal's RBAC assignments, then authorization is immediately resolved and no additional ACL checks are performed. Alternatively, if the security principal does not have an RBAC assignment, or the request's operation does not match the assigned permission, then ACL checks are performed to determine if the security principal is authorized to perform the requested operation.
See this article for details.
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
Control file and folder handling in Power Automate for desktop - Training
Learn about the files and folders actions in Microsoft Power Automate for desktop.
Certification
Microsoft Certified: Azure Data Fundamentals - Certifications
Demonstrate foundational knowledge of core data concepts related to Microsoft Azure data services.