SSIS CSV file Destination

SSIS CSV file Destination

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).


  • 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 of file size
  • Supports dynamic file paths (Use variable in File Path).
  • Easy to use source to target column mapping
  • Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
  • Click here to see articles related to CSV components
SSIS Amazon SQS Source Connector - Video Tutorial
Download Help File Buy
View All Tasks
ScreenshotsUseful LinksSystem Requirements

SSIS CSV File Destination – FILE Connection

SSIS CSV File Destination ( FILE Connection)

CSV File destination support 3 ways to supply file path. Via FILE connection manager, FLATFILE Connection Manager and you set path in FilePath Property.

SSIS CSV File Destination – Properties

CSV File Destination Properties

CSV File Destination Property Screen

SSIS CSV File Destination – Mappings Screen

CSV File Destination input columns

You can select which columns you like to output in CSV File. You can also rename header column names for CSV File.

SSIS CSV File Destination – Create multiple Compressed CSV Files (With auto split by row count)

CSV destination example compression

It supports GZip (*.gz) and Zip compression mode. You can also Split files by Row count or Size. Automatically creates multiple files.

Articles / Tutorials

Click here to see all articles for [SSIS CSV File Destination] category

How to write data into CSV file in SSIS (GZip / Split)

How to write data into CSV file in SSIS (GZip / Split)

Introduction In this article, we will see how to read How to write data into CSV file in SSIS from SQL Server. We will also explain how to compress (gzip) and split  CSV files into multiple files. To illustrate, we will use ZappySys SSIS PowerPack, which includes several tasks to import/export data from multiples sources to […]

Load PostgreSQL Table Data to CSV File in SSIS

Load PostgreSQL Table Data to CSV File in SSIS

Introduction ZappySys provides high performance drag and drop connectors for PostgreSQL Integration. In this post you will see how to Load PostgreSQL Table Data to CSV File using SSIS PostgreSQL Source. PostgreSQL Source supports SQL language to query PostgreSQL data. PostgreSQL is a powerful, open source relational database with strong reputation for reliability, feature robustness, and performance. In […]

Click here to learn more about System Requirements
Download View All Tasks Like This