Included in SSIS PowerPack

SSIS Azure Blob CSV File Destination

Write CSV files to Azure Blob Storage from any SSIS source, with no local staging files.

SSIS Azure Blob Destination for CSV File can be used to write data in CSV file format to Azure Blob Storage. You can automatically split large files by row count or size at runtime. It also supports writing files directly in compressed format such as GZip (*.gz).

Download Free Trial Buy Now

The trial includes Azure Blob CSV File Destination and every other PowerPack component

Help & Docs
Azure Blob CSV File Destination in SSDT
Azure Blob CSV File Destination - Create Azure Storage Connection Manager
Azure Storage Connection Manager: enter your storage account credentialsExplore the UI →

Trusted by data teams worldwide

MicrosoftIBMOracleDell TechnologiesHPCiscoAT&TVerizonDHLFedExUPSWalmart

Also rated on Capterra★★★★★ , Trustpilot★★★★★ and BBBA+ — see why teams trust ZappySys

At a glance

What Azure Blob CSV File Destination can do

SSIS Azure Blob Destination for CSV File can be used to write data in CSV file format to Azure Blob Storage. You can automatically split large files by row count or size at runtime. It also supports writing files directly in compressed format such as GZip (*.gz).

Write CSV to Azure Blob

Create CSV files directly in Azure Blob Storage from any source (e.g. SQL Server, Oracle, MySQL) without creating local files.

  • Append to a file (Append) or overwrite it (OverwriteFileIfExists)
  • DoNotCreateFileIfNoRows skips the empty file when there are no input rows

SQL Server to Azure Blob guide

Split large files

Automatically split large output into multiple files by row count or file size at runtime.

  • EnableFileSplit with FileSplitMode ByRowCount or BySize
  • MaxRowsPerFile or MaxSizePerFile (e.g. 100mb)

Split files & GZip guide

Compressed output

Write files directly in compressed format in stream mode.

  • CompressionType: GZip, Zip or TarGZip
  • Add the matching extension (e.g. *.gz or *.zip) to the file path

Component properties

Dynamic file path

Set the target path directly or read it from an SSIS variable, with variable placeholders anywhere in the path.

  • AccessMode: Direct or Variable (FilePathVariable)
  • e.g. myroot/folder/file_{{System::StartTime,yyyyMMdd}}.dat

Component properties

Delimiters, quotes & header

Control the layout of the generated CSV file.

  • ColumnDelimiter and RowDelimiter accept \t, {TAB}, {CRLF} or hex codes such as \xNN
  • FirstRowHasColumnNames, QuotesAroundValue and QuoteChar
  • DateTimeFormat for date/time columns

Component properties

Encoding & escape rules

Choose the file encoding and define custom character replacement rules.

  • Encoding (UTF-8, UTF-16, with or without BOM, and more) or CharacterSet (e.g. ISO-8859-1 or a code page)
  • EnableCustomEscapeSequence with CustomEscapeSequenceRule key=value pairs

Component properties

Azure Storage connection

Connect through the Azure Storage Connection Manager with an account name and access key, a SAS URL or token, a connection string, or the local Azure Storage Emulator.

  • Custom Blob, Table and Queue endpoints
  • Proxy settings, plus Timeout, MaxRetryOnError and RetryInterval

Connection Manager help

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

Compatibility and requirements

Logging control

Control how much information is logged during package execution.

  • LoggingMode: Normal, Medium, Detailed or Debugging
  • PrefixTimestamp adds a timestamp to log messages

Component properties

See all features
  • Create CSV files directly in Azure Blob from any source (e.g. SQL Server, Oracle, MySQL) without creating local files
  • Create compressed files in stream mode (GZip, Zip or TarGZip)
  • Split files by row count or file size
  • Dynamic file path from a variable or with placeholders such as {{User::FileName}}
  • Append to an existing file or overwrite the target file
  • Option to skip creating an empty file when there are no input rows
  • Custom column and row delimiters, including special keywords and hex codes
  • Optional header row and quotes around values
  • Custom date/time format for date columns
  • Choice of encoding or character set
  • Custom escape sequence rules to search and replace characters
  • Pick the input columns to write on the Input Columns tab
  • Connect with access key, SAS URL/token, connection string or the Azure Storage Emulator
  • Logging modes (Normal, Medium, Detailed, Debugging) with optional timestamp prefix

  • Support for SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit) and Azure Data Factory

Runs in your environment ·

SQL Server 2012–2025

and Azure-SSIS · Read the FAQ

How it works

From the toolbox to your first run.

Key steps from the Azure Blob CSV File Destination page and help file, with the screens you will see in SSDT.

Create an Azure Storage connection.

Right-click the Connection Managers panel, choose New Connection, pick ZS-AZURE-STORAGE and enter your storage account credentials (or use the local Azure Storage Emulator). Click Test Connection, then OK.

  • Account name and key, SAS URL/token or connection string
  • Custom Blob endpoint and proxy settings
  • Timeout and retry-on-error settings
Azure Blob CSV File Destination - Create Azure Storage Connection Manager

Inside the UI

Key settings, as they appear in SSDT.

Real screens from the Azure Blob CSV File Destination product page. Step through them, or open any shot at full size.

Azure Blob CSV File Destination – Create Azure Storage Connection

Configure the ZS-AZURE-STORAGE connection with your storage account credentials, or use the local Azure Storage Emulator, then click Test Connection.

Articles

Worked examples that use Azure Blob CSV File Destination.

GuideSQL Server to Azure Blob (split files, GZip)Export large SQL Server tables to Azure Blob as split, GZip-compressed CSV files, three ways, including this destination.zappysys.com blogRead articleGuideRead Azure Blob files in SSIS (CSV, JSON, XML)Read the files back with the Azure Blob CSV, JSON and XML sources, including wildcards and compressed files.zappysys.com blogRead articleGuideAzure Blob Storage Task examplesUpload, download, copy, move and delete blobs and containers from the Control Flow.zappysys.com blogRead articleCollectionAll Azure Blob CSV File Destination articlesMore tutorials from the ZappySys blog.zappysys.com blogBrowse all articles

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 Destination on the canvas.

What is Azure Blob CSV File Destination?

A Data Flow destination that writes data in CSV format straight to Azure Blob Storage from any SSIS source (for example SQL Server, Oracle or MySQL) without creating local files. It can split large output into multiple files by row count or size and write GZip, Zip or TarGZip compressed files in stream mode.

How do I split output into multiple files?

Set EnableFileSplit to true and choose a FileSplitMode: ByRowCount with MaxRowsPerFile, or BySize with MaxSizePerFile (e.g. 100mb). See the property reference.

How do I write a compressed (.gz or .zip) file?

Set CompressionType to GZip, Zip or TarGZip. The extension is not added for you, so include it in the file path yourself (e.g. mycontainer/data/orders.csv.gz).

Can the file name change on every run?

Yes. Use variable placeholders anywhere in FilePath, such as myroot/folder/file_{{System::StartTime,yyyyMMdd}}.dat, or set AccessMode to Variable and read the full path from FilePathVariable.

What is the fastest way to move a very large table to Azure Blob?

For very large data ZappySys recommends two steps: export to local split, compressed CSV files with the Export CSV Task, then upload them in parallel with the Azure Blob Storage Task. Use this destination when you need Data Flow transformations before writing. See the step-by-step guide.

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.

Independent ratings

Trusted by data teams, recognized by the industry

See why teams trust ZappySys (opens in new tab)

What customers say

  • Customer story

    ZappySys has been a fantastic way to bring our small company into the world of APIs, automation, and systems integration by providing tools within an easy-to-use framework.

    Ben KingeryOxspring Paul
  • Customer story

    At Synchronous Customers, we need to connect various types of data quickly. The super handy ZappySys connectors and great documentation let us do it without writing a lot of code.

    Joel ConnerSynchronous Customers
  • Customer story

    I looked everywhere for a product that could integrate to a web portal backend API via JSON. After many attempts, ZappySys was the only solution that gave me all the options I needed in a quick & clean interface within SSIS.

    Maz DunicSave the Children Australia
  • Customer story

    We have worked with the ZappySys support team for over a year and have consistently found them extremely helpful — resourceful and creative in offering multiple solutions to our challenges.

    Senthil SekarPublicis Groupe
  • Trustpilot

    I’ve been using ZappySys for over 6 years — it makes development faster, and I introduced it to my current company.

    Anna JohnsonTrustpilot review
  • Trustpilot

    I’m integrating data from APIs into database tables with SSIS/ZappySys — very easy to use, fast, and highly efficient without writing complex code.

    Carolyn S.Trustpilot review
  • Customer quote

    I submitted a support request and had someone logged in and fixing things within 2 hours.

    Barry Wilson
  • Customer quote

    The REST source is very powerful — the only thing I found I could use after trying components from major vendors.

    Jes KirkupKTC
  • Customer quote

    Whenever we run into an obstacle, ZappySys has a solution for us. We are so glad that we chose ZappySys PowerPack.

    Kevin ChenBerricle

Start your free trial today

Install SSIS PowerPack and drag Azure Blob CSV File Destination onto the Data Flow.

Write CSV files to Azure Blob Storage from any SSIS source, with splitting and compression built in.

  • Data Flow Destination in SSISAzure Blob CSV File Destination 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.
Download Free TrialView Pricing

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.

+1-800-444-5602Contact supportSSIS PowerPack overview

1 / 4