Included in SSIS PowerPack

SSIS CSV Destination

Write data in CSV / TSV file format.

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

The trial includes CSV Destination and every other PowerPack component

SSIS data flow writing 1,000,000 SQL Server rows into multiple GZip compressed CSV files with CSV Destination
Write one large source into multiple compressed CSV files

Trusted by data teams worldwide

MicrosoftIBMOracleDell TechnologiesHPCiscoAT&TVerizonDHLFedExUPSWalmart

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

At a glance

What CSV Destination can do

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

CSV, TSV or custom delimited

Create comma separated, tab separated or custom delimited files from any SSIS source.

  • ColumnDelimiter and RowDelimiter accept {TAB}, {CRLF} or hex codes such as \xNN
  • FirstRowHasColumnNames for an optional header row

Write CSV file guide

Split large files

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

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

Write CSV file guide

Compressed output

Write plain text or compressed files directly.

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

Component properties

Dynamic file paths

Supply the file path through a FILE or FLATFILE connection manager, or set it in the FilePath property.

  • Variable placeholders, e.g. file_{{System::StartTime,yyyyMMdd}}.dat
  • AccessMode Variable with FilePathVariable

Component properties

Column mapping

Choose which input columns to write to the CSV file.

  • Rename header column names on the mappings screen

See the mapping screen

Quoting & date format

Control how values are quoted and how dates are written.

  • QuotesAroundValue with a custom QuoteChar
  • DateTimeFormat for date and datetime columns

Component properties

Append & overwrite control

Choose how existing and empty files are handled.

  • Append or OverwriteFileIfExists
  • DoNotCreateFileIfNoRows skips empty files when there are no input rows

Component properties

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

Encoding & escape rules

Set the output encoding and replace special characters with custom rules.

  • Encoding (UTF-8, UTF-16, with or without BOM) or CharacterSet (e.g. ISO-8859-1)
  • EnableCustomEscapeSequence with CustomEscapeSequenceRule

Component properties

See all features
  • Create CSV (comma separated), TSV (tab separated) or custom delimited files from any SSIS source
  • Output as plain text or compressed file (GZip *.gz or Zip)
  • Automatic file splitting by row count or file size
  • Dynamic file paths using variables in the file path
  • File path from a FILE or FLATFILE connection manager or the FilePath property
  • Easy source to target column mapping, with renamed header columns
  • Optional header row with column names
  • Optional quotes around values with a custom quote character
  • Custom date/time format for date columns
  • Append to or overwrite existing files
  • Option to not create a file when there are no input rows
  • Encoding and character set options
  • Custom escape sequence rules to replace special characters
  • 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 CSV Destination page and help file, with the screens you will see in SSDT.

Supply the file path three ways.

CSV Destination accepts the target path from a FILE connection manager, a FLATFILE connection manager, or the FilePath property. With a FILE connection, set Usage type to Create file or Existing file.

  • Variable placeholders in the path, e.g. file_{{System::StartTime,yyyyMMdd}}.dat
  • AccessMode Variable with FilePathVariable
  • Add .gz or .zip when you enable compression
SSIS File Connection Manager Editor pointing to the target CSV file

Inside the UI

Key settings, as they appear in SSDT.

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

FILE connection

CSV Destination can take the path from a FILE connection manager, a FLATFILE connection manager or the FilePath property.

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

What is CSV Destination?

A Data Flow Destination in SSIS PowerPack that writes data from any SSIS source to CSV, TSV or custom delimited files. It can write GZip or Zip compressed files and split large output into multiple files by row count or size at runtime.

How do I set the output file path?

Three ways: a FILE connection manager, a FLATFILE connection manager, or the FilePath property. The path can contain variable placeholders such as {{System::StartTime,yyyyMMdd}}, or come from a variable with AccessMode Variable.

How do I split a large file?

Set EnableFileSplit to True and FileSplitMode to ByRowCount (MaxRowsPerFile) or BySize (MaxSizePerFile, e.g. 100mb). See How to write data into CSV file in SSIS.

Can I append to an existing file or skip empty files?

Yes. Use Append to add rows to an existing file or OverwriteFileIfExists to replace it. DoNotCreateFileIfNoRows skips creating a file when there are no input rows.

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 CSV Destination onto the Data Flow.

Create CSV, TSV or custom delimited files from any SSIS source, compressed or plain, split automatically by row count or size.

  • Data Flow Destination in SSISCSV 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.

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 / 4