CSV Generator Transform

SSIS CSV Generator Transform

SSIS CSV Generator Transform can be used to generate single or multiple CSV strings from any type of datasources (e.g. SQL Server, MySQL, Flat File, Excel) inside data flow task.

Features

  • Create CSV , TSV (Tab delimited) strings
  • Supports different cultures
  • Allows static value elements
  • Custom row and column delimiters
  • Supports custom header and footer
  • Preview data supported in UI
  • Output in batch mode (output X number of rows in each output string)
  • Supports encoding (e.g. UTF8, UTF16 with or without BOM)
  • Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
  • Click here to see related articles
 SSIS Video Tutorial
See also
CSV File Source
CSV Parse Transform
SSIS Web API Destination - Send data to API Web API Destination
Secure FTP CSV file destination Task
Download Help File Buy View All Tasks
ScreenshotsUseful LinksSystem Requirements

SSIS CSV Generator Transform – UI (Batch Records Example)

SSIS CSV Generator Transform UI (Batch Records Example)

The UI from CSV generator transform with the output mode, it has 2 options

SSIS CSV Generator Transform – Add Columns for CSV Output

CSV generator transform - Add Columns for CSV Output

Select a new column for the CSV output, it can be a static value

SSIS CSV Generator Transform – Select a column to edit or delete it

CSV generator remove or edit a column

You can edit or remove a column

SSIS CSV Generator Transform – Options for SSIS CSV Generator Transform

Options for SSIS CSV Generator Transform

Options for SSIS CSV Generator Transform (e.g. Row delimiter, Column Delimiter)

SSIS CSV Generator Transform – Header / Footer Options for CSV data

Header / Footer Options for CSV data

Header and Footer Options

SSIS CSV Generator Transform – Sending a CSV to an API

CSV generator transform - Example Result

We used a JSON source to generate a new CSV output and then send it to an API with Web API destination

Articles / Tutorials

Click here to see all articles for [SSIS CSV Generator Transform] category


How to read YouTube API data in SSIS (Videos, Channels, Playlists)

How to read YouTube API data in SSIS (Videos, Channels, Playlists)

Introduction In last few articles we saw how to read data from various Google Services. In this article we will see how to read YouTube API data in SSIS. This blog mainly focus on SSIS approach but steps mentioned to call Google APIs can be useful for any developer regardless which programming language or toolset […]


How to batch REST API requests in SSIS (Bulk Operation)

How to batch REST API requests in SSIS (Bulk Operation)

Introduction In our previous article we saw how to POST data to REST API using few different ways. Now let’s go one step further and discuss another common scenario to batch REST API requests in SSIS. For efficient data transfer many API provides you to submit multiple records in a single request. In this article […]

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