SSIS CSV Generator Transform
Generate CSV strings from any source inside the Data Flow.
SSIS CSV Generator Transform can be used to generate single or multiple CSV strings from any type of data source (e.g. SQL Server, MySQL, Flat File, Excel) inside the Data Flow Task.
The trial includes CSV Generator Transform and every other PowerPack component
- Data Flow Transform in SSIS
- Runs in your environment
- Also runs in Azure Data Factory
- Fully functional 30-day trial

At a glance
What CSV Generator Transform can do
SSIS CSV Generator Transform can be used to generate single or multiple CSV strings from any type of data source (e.g. SQL Server, MySQL, Flat File, Excel) inside the Data Flow Task.
Generate CSV in the Data Flow
Generate single or multiple CSV or TSV strings from any data source, such as SQL Server, MySQL, Flat File or Excel, inside the Data Flow Task.
- Preview the generated data in the UI
Single or per-row output
Choose one CSV for all input rows or one CSV document per parent row.
OutputMode: SingleFileFormat (batching allowed) or MultiFileFormatArrayBatchSizeoutputs X rows in each CSV string
Column layout & static values
Add input columns to the CSV output, add static values, and edit or remove columns.
- Add many bound columns at once with Select All
- Static value elements
Custom header & footer
Add header and footer text around each generated document.
DocumentHeaderandDocumentFooterUseColumnForHeaderFooterreads the text from an upstream column
Delimiters & quoting
Set custom row and column delimiters and control quoting.
RowDelimiterandColumnDelimiteraccept {TAB}, {CRLF} or hex codesQuotesAroundValueandAlwaysQuote(quote numbers too)FirstRowHasColumnNamesfor an optional header row
Culture & date formats
Format numbers and dates for the target region.
Culturecontrols the decimal indicator and other regional formatsDateTimeFormatsets the default output format for datetime columns
Encoding options
Choose the encoding of the generated CSV.
- UTF-8, UTF-16 and more, with or without BOM
CharacterSetname or code page (e.g. ISO-8859-1)
SQL Server 2012–2025 & ADF
Runs in your environment on SQL Server 2012–2025 and Azure-SSIS.
- SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit)
- Azure Data Factory (SSIS IR)
- Design packages in Visual Studio 2017, 2019, 2022, or 2026
- Windows only (64-bit OS): Windows 7–11 or Windows Server 2012–2025
Batch CSV to REST APIs
Generate CSV in batches and send it to an API with Web API Destination.
- e.g. post 5 rows per API call using
ArrayBatchSize
See all features
- Create CSV and TSV (tab delimited) strings
- Generate single or multiple CSV strings from any data source inside the Data Flow
- Output one CSV for all input rows or one CSV per parent row
- Output in batch mode (X rows in each output string)
- Allows static value elements
- Custom row and column delimiters
- Custom header and footer, from a fixed string or an upstream column
- Optional quotes around values, including numbers
- Supports different cultures
- Default output format for datetime columns
- Supports encoding (e.g. UTF-8, UTF-16 with or without BOM)
- Preview data in the UI
- Send generated CSV to a REST API with Web API Destination
Support for SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit) and Azure Data Factory
SQL Server 2012–2025
How it works
From the toolbox to your first run.
Key steps from the CSV Generator Transform page and help file, with the screens you will see in SSDT.
One CSV for many rows, or one CSV per row.
Set Output Mode to Output Single Csv for multiple input rows (Batching Allowed) or Output One Csv Document per parent row. With the single mode, Batch Size outputs X rows in each CSV string (0 = all rows in one string).
- Live preview of the generated CSV with sample data
- Mapping code view of the layout

Add the columns you want in the CSV.
Right-click Mappings (or use the toolbar) and choose Add Element(s) to pick input columns, or Add Static Element for a fixed value. Selected columns can later be edited or removed.
- Add Multiple (Bound) with Select All
- Static value elements

Delimiters, quoting, culture and encoding.
The Options tab sets the date/time output format, culture, encoding or character set, column and row delimiters, the header row, and whether values are wrapped in quotes.
- Custom delimiters, including hex codes such as
\x0009 AlwaysQuotequotes numbers and booleans too- UTF-8, UTF-16 and more, with or without BOM

Post generated CSV to a REST API.
In this example a JSON source feeds CSV Generator Transform, and Web API Destination posts each generated CSV string to an API. Combine it with Batch Size to send several rows per request.

Inside the UI
Key settings, as they appear in SSDT.
Real screens from the CSV Generator Transform product page. Step through them, or open any shot at full size.
Output mode and batch size
Choose one CSV for all input rows (batching allowed) or one CSV document per parent row; Batch Size sets how many rows go in each CSV string.
Articles
Worked examples that use CSV Generator Transform.
Compatibility and requirements
Designed to stay inside your SSIS runtime.
- SQL Server 2012 through 2025, 32-bit and 64-bit
- Windows only, 64-bit OS required. SQL Server Express and Web editions do not include SSIS
- Azure Data Factory SSIS Integration Runtime
- Self-hosted: credentials and data stay in your environment (external API calls still reach that service)
- Fully functional 30-day trial of SSIS PowerPack
FAQ
Questions teams ask before they drop CSV Generator Transform on the canvas.
What is CSV Generator Transform?
A Data Flow Transform in SSIS PowerPack that generates CSV or TSV strings from any upstream source (e.g. SQL Server, MySQL, Flat File, Excel). It can output one CSV for all input rows, in batches, or one CSV per row.
Can I output a fixed number of rows per CSV string?
Yes. Use OutputModeOutput Single Csv for multiple input rows and set ArrayBatchSize (Batch Size) to the number of rows per string; 0 puts all rows in one string.
Can I add a header or footer?
Yes. DocumentHeader and DocumentFooter add text before and after each document, with SSIS variable and column placeholders. With UseColumnForHeaderFooter the text comes from an upstream column.
How do I send the CSV to a REST API?
Connect the transform to Web API Destination. The batch REST API requests guide shows how to send CSV in batches with the header only in the first batch.
Which SQL Server versions can I run it on?
SQL Server 2025, 2022, 2019, 2017, 2016, 2014, and 2012 (32- and 64-bit), plus Azure Data Factory with an SSIS Integration Runtime (packages must target SQL Server 2017). See Compatibility and requirements.
Start your free trial today
Install SSIS PowerPack and drag CSV Generator Transform onto the Data Flow.
Turn rows from any source into CSV or TSV strings, one per row or in batches, ready to send to an API or another destination.
- Data Flow Transform in SSISCSV Generator Transform appears in the toolbox after you install PowerPack.
- Fully functional 30-day trialSSIS PowerPack, running in your environment.
- Live supportHelp during your trial and after purchase.
Open Help FileBrowse all SSIS PowerPack tasks
New purchases may be eligible for refund review within 30 days. See the refund policy.
Talk to an engineer before or during your trial.