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 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
- Click here to see articles related to CSV components
|| View All Tasks
Download View All Tasks Like This
ScreenshotsUseful LinksSystem Requirements
Create multiple Compressed CSV Files (With auto split by row count)
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 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 File Destination Property Screen
Mappings Screen for SSIS CSV Destination
You can select which columns you like to output in CSV File. You can also rename header column names for CSV File.
to learn more about System Requirements