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
- Data Flow Destination in SSIS
- Runs in your environment
- Also runs in Azure Data Factory
- Fully functional 30-day trial

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.
ColumnDelimiterandRowDelimiteraccept {TAB}, {CRLF} or hex codes such as\xNNFirstRowHasColumnNamesfor an optional header row
Split large files
Automatically split output into multiple files by row count or file size at runtime.
EnableFileSplitwithFileSplitModeByRowCount or BySizeMaxRowsPerFileorMaxSizePerFile(e.g.100mb)
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
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 AccessModeVariable withFilePathVariable
Column mapping
Choose which input columns to write to the CSV file.
- Rename header column names on the mappings screen
Quoting & date format
Control how values are quoted and how dates are written.
QuotesAroundValuewith a customQuoteCharDateTimeFormatfor date and datetime columns
Append & overwrite control
Choose how existing and empty files are handled.
AppendorOverwriteFileIfExistsDoNotCreateFileIfNoRowsskips empty files when there are no input rows
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 & escape rules
Set the output encoding and replace special characters with custom rules.
Encoding(UTF-8, UTF-16, with or without BOM) orCharacterSet(e.g. ISO-8859-1)EnableCustomEscapeSequencewithCustomEscapeSequenceRule
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
*.gzor 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
FilePathproperty - 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
SQL Server 2012–2025
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 AccessModeVariable withFilePathVariable- Add
.gzor.zipwhen you enable compression

Pick and rename the columns to write.
On the Input Columns tab, tick the columns you want in the CSV file. The Output Alias becomes the header name, so you can rename header columns here.
- Leave out columns you do not need
FirstRowHasColumnNamescontrols the header row

Split large output into multiple files.
In Component Properties set EnableFileSplit to True and FileSplitMode to BySize or ByRowCount. Each run then creates numbered part files such as .001.part.csv, .002.part.csv.
MaxRowsPerFilefor ByRowCountMaxSizePerFile(e.g.10mb) for BySize- Combine with
CompressionTypeGZip or Zip

Assign the file connection to the destination.
Open the destination in the Advanced Editor and, on Connection Managers, set RuntimeConnection to the FILE or FLATFILE connection that holds the target path.
- Or leave it empty and use the
FilePathproperty

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.
Articles
Worked examples that use CSV Destination.
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.
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.
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.