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 Source component enables an SSIS package to read data from various supported storage services. Currently supported storage services are
To see the editor for the Flexible File Source, drag and drop Flexible File Source on the data flow designer and double-click it to open the editor.
The Flexible File Source is a component of the SQL Server Integration Services (SSIS) Feature Pack for Azure.
Following properties are available on the Flexible File Source Editor.
Following properties are available on the Advanced Editor.
After you specify the connection information, switch to the Columns page to map source columns to destination columns for the SSIS data flow.
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 permission is granted by assigning at least Storage Blob Data Reader role.
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. For read permission, grant at least Execute permission starting from the source file system, along with Read permission for the files to read. Alternatively, grant at least the Storage Blob Data Reader role with RBAC. 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
Learning path
Large-Scale Data Processing with Azure Data Lake Storage Gen2 - Training
Large-Scale Data Processing with Azure Data Lake Storage Gen2
Certification
Microsoft Certified: Azure Data Fundamentals - Certifications
Demonstrate foundational knowledge of core data concepts related to Microsoft Azure data services.