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

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 of file size
  • Supports dynamic file paths (Use variable in File Path).
  • Easy to use source to target column mapping
  • Support for SQL Server 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

Featured Articles

ScreenshotsUseful LinksSystem Requirements

Create multiple Compressed CSV Files (With auto split by row count)

SSIS CSV File destination supports GZip and Zip compression mode. You can also Split files by Row count or Size. Automatically create multiple files.

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

SSIS CSV File Destination ( FILE Connection)

CSV Destination - 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.

CSV File Destination Properties

CSV Destination - configuration

CSV File Destination Property Screen

Mappings Screen for SSIS CSV Destination

Select CSV File destination Columns

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

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