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

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

You can edit or remove a column

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

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)

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 […]