SSIS Azure Blob Source for CSV File

SSIS Azure Blob Source for CSV File can be used to read CSV files from Microsoft Azure Blob Storage. You can extract data from single or multiple files (wildcard pattern supported). Also you can read compressed files (*.gz) without extracting files on disk.

Features

• Support for reading single or multiple files stored in Azure Blob Storage (wildcard pattern supported e.g. *.csv)
• Support for reading zip and gzip compressed files (stream mode)
• Support for missing columns at the end (Auto fill with null values)
• Support for data pivot (transform columns into rows)
• Support for comments in the file
• Support for advanced error handling such as throw error for empty file, throw error when column count mismatch
• Support for Advanced parser options such as Trim fields, Trim headers, Skip rows
• Support for ignoring blank lines and blank rows (no data for each column)
• Support for Dynamic file path using variable placeholder (e.g. /myroot/{{User::MyFolder}}/*.csv )
• Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
• Click here to see more articles on Azure related articles
• Click here to see more articles on CSV related articles