SSIS Azure Blob CSV File Source
Read one or many CSV files from Azure Blob Storage, including GZip and Zip files, without downloading them first.
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.
The trial includes Azure Blob CSV File Source and every other PowerPack component
- Data Flow Source in SSIS
- Runs in your environment
- Also runs in Azure Data Factory
- Fully functional 30-day trial
At a glance
What Azure Blob CSV File Source can do
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.
Read one or many files
Read a single CSV file or many files from Azure Blob Storage using a wildcard pattern (e.g. *.csv).
- Pick files with the Blob Browser UI
Recursiveincludes files from subfoldersEnableMultiPathModereads a list of paths as one dataset
Compressed files
Read Zip and GZip compressed files in stream mode, without extracting them on disk.
FileCompressionType: GZip, Zip or TarGZip
Dynamic file path
Build the file path at runtime with variable placeholders (e.g. /myroot/{{User::MyFolder}}/*.csv).
OutputFilePathandOutputFileNameadd__FilePath/__FileNamecolumnsContinueOnFileNotFoundErrorcontinues when a file is missing
Advanced parser options
Fine-tune how the CSV text is parsed.
TrimFields,TrimHeaders,SkipRowsandSkipHeaderCommentRows- Comment lines (
AllowComment,CommentCharacter) - Custom
ColumnDelimiter(hex codes allowed) andQuoteCharacter
Blank & missing values
Missing columns at the end of a row are auto-filled with null values.
IgnoreBlankLinesandSkipEmptyRecordsskip blank lines and empty rowsTreatBlankAsNull, plus blank-as-null options for number, bool and date columns
Advanced error handling
Throw errors for problem files and redirect bad records to the error output.
ThrowErrorOnNoRecordFoundfor an empty fileThrowErrorOnColumnCountMismatchwhen a row has a different column count
Pivot & search/replace
Transform columns into rows, and clean the text before it is parsed.
EnablePivotoutputsPivot_NameandPivot_ValuecolumnsEnableCustomReplacewith plain or regexSearchFor/ReplaceWith
SQL Server 2012–2025 & ADF
Runs in your environment on SQL Server 2012–2025 and Azure-SSIS.
- SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit)
- Azure Data Factory (SSIS IR)
- Design packages in Visual Studio 2017, 2019, 2022, or 2026
- Windows only (64-bit OS): Windows 7–11 or Windows Server 2012–2025
Encoding, culture & types
Control encoding, number and date parsing, and how column types are detected.
EncodingorCharacterSet, andCulturefor number formatsDateParseHandlingandFloatParseHandling(Decimal for high precision)MetaDataScanModesets how data type and length are detected
See all features
- Read single or multiple files stored in Azure Blob Storage (wildcard pattern supported e.g. *.csv)
- Read Zip and GZip compressed files in stream mode
- Missing columns at the end are auto-filled with null values
- Data pivot (transform columns into rows)
- Comment lines in the file are skipped
- Error handling: throw error for an empty file or when the column count does not match
- Advanced parser options such as trim fields, trim headers and skip rows
- Ignore blank lines and rows with no data in any column
- Dynamic file path using variable placeholders (e.g.
/myroot/{{User::MyFolder}}/*.csv) - Select files with the Blob Browser UI and preview data at design time
- Redirect bad records to the error output
- Output file path and file name as extra columns
- Connect with access key, SAS URL/token, connection string or the Azure Storage Emulator
Support for SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit) and Azure Data Factory
SQL Server 2012–2025
How it works
From the toolbox to your first run.
Key steps from the Azure Blob CSV File Source page and help file, with the screens you will see in SSDT.
Pick the connection and the blob path, then preview.
Select the Azure Storage connection, then type the path or click the browse button to pick a file in the Blob Browser. Use a wildcard such as *.csv to read many files in one go, set the column delimiter and header option, and click Preview to check the data.
- Single file or wildcard pattern
- Variable placeholders in the path
- Design-time data preview
Read GZip or Zip files without extracting them.
On the GZip/Zip Compression tab, choose the file compression format. The file is parsed in stream mode, so there is no need to decompress it to local disk first. Wildcards work here too (e.g. *.gz).
FileCompressionType: GZip, Zip or TarGZip- No local extract step
Handle comments, blank lines and stray whitespace.
The Advanced tab controls how the CSV text is parsed: skip comment lines that start with a chosen character, ignore blank lines, trim headers and fields, ignore a quote character, and skip records that have no values in any field.
AllowCommentwithCommentCharacterIgnoreBlankLinesandSkipEmptyRecordsTrimHeadersandTrimFields
Fail fast on empty files or ragged rows.
The Error Handling tab can throw an error when a row has a different column count than the first row, or when no record is found or the file is blank. Bad records can also be redirected to the SSIS error output.
ThrowErrorOnColumnCountMismatchThrowErrorOnNoRecordFound
Inside the UI
Key settings, as they appear in SSDT.
Real screens from the Azure Blob CSV File Source product page. Step through them, or open any shot at full size.
Azure Blob CSV File Source – Read from CSV File Options
Select the storage connection, enter or browse to the file path, set the compression format and click Preview to see sample rows.
Articles
Worked examples that use Azure Blob CSV File Source.
Compatibility and requirements
Designed to stay inside your SSIS runtime.
- SQL Server 2012 through 2025, 32-bit and 64-bit
- Windows only, 64-bit OS required. SQL Server Express and Web editions do not include SSIS
- Azure Data Factory SSIS Integration Runtime
- Self-hosted: credentials and data stay in your environment (external API calls still reach that service)
- Fully functional 30-day trial of SSIS PowerPack
FAQ
Questions teams ask before they drop Azure Blob CSV File Source on the canvas.
What is Azure Blob CSV File Source?
A Data Flow source that parses CSV files stored in Azure Blob Storage. It reads a single file or many files with a wildcard pattern (e.g. *.csv), and it reads GZip or Zip compressed files in stream mode without extracting them to local disk.
How do I read many files in one go?
Put a wildcard in the path (e.g. /myroot/{{User::MyFolder}}/*.csv). Set Recursive to include subfolders, or turn on EnableMultiPathMode to list several paths separated by a new line or ::. Files should share a similar structure.
Can I tell which file each row came from?
Yes. Set OutputFileName or OutputFilePath to true to add __FileName or __FilePath columns to the output.
What happens if the file does not exist?
By default the package stops with a file-not-found error. Set ContinueOnFileNotFoundError to true to continue instead. See the property reference.
Which SQL Server versions can I run it on?
SQL Server 2025, 2022, 2019, 2017, 2016, 2014, and 2012 (32- and 64-bit), plus Azure Data Factory with an SSIS Integration Runtime (packages must target SQL Server 2017). See Compatibility and requirements.
What customers say
Start your free trial today
Install SSIS PowerPack and drag Azure Blob CSV File Source onto the Data Flow.
Read one or many CSV files from Azure Blob Storage, including compressed files, straight into your Data Flow.
- Data Flow Source in SSISAzure Blob CSV File Source appears in the toolbox after you install PowerPack.
- Fully functional 30-day trialSSIS PowerPack, running in your environment.
- Live supportHelp during your trial and after purchase.
Open Help FileBrowse all SSIS PowerPack tasks
New purchases may be eligible for refund review within 30 days. See the refund policy.
Talk to an engineer before or during your trial.