Included in SSIS PowerPack

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

CSV Generator Transform in SSDT
CSV Generator Transform UI (Batch Records Example)
Choose one CSV for all rows (with batching) or one CSV per rowExplore the UI →

Trusted by data teams worldwide

MicrosoftIBMOracleDell TechnologiesHPCiscoAT&TVerizonDHLFedExUPSWalmart

Also rated on Capterra★★★★★ , Trustpilot★★★★★ and BBBA+ — see why teams trust ZappySys

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

Component help

Single or per-row output

Choose one CSV for all input rows or one CSV document per parent row.

  • OutputMode: SingleFileFormat (batching allowed) or MultiFileFormat
  • ArrayBatchSize outputs X rows in each CSV string

Component properties

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

See the screenshots

Custom header & footer

Add header and footer text around each generated document.

  • DocumentHeader and DocumentFooter
  • UseColumnForHeaderFooter reads the text from an upstream column

Component properties

Delimiters & quoting

Set custom row and column delimiters and control quoting.

  • RowDelimiter and ColumnDelimiter accept {TAB}, {CRLF} or hex codes
  • QuotesAroundValue and AlwaysQuote (quote numbers too)
  • FirstRowHasColumnNames for an optional header row

Component properties

Culture & date formats

Format numbers and dates for the target region.

  • Culture controls the decimal indicator and other regional formats
  • DateTimeFormat sets the default output format for datetime columns

Component properties

Encoding options

Choose the encoding of the generated CSV.

  • UTF-8, UTF-16 and more, with or without BOM
  • CharacterSet name or code page (e.g. ISO-8859-1)

Component properties

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

Compatibility and requirements

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

Batch REST API requests

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

Runs in your environment ·

SQL Server 2012–2025

and Azure-SSIS · Read the FAQ

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
CSV Generator Transform Output Mode drop-down and Batch Size

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.

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.

Independent ratings

Trusted by data teams, recognized by the industry

See why teams trust ZappySys (opens in new tab)

What customers say

  • Customer story

    ZappySys has been a fantastic way to bring our small company into the world of APIs, automation, and systems integration by providing tools within an easy-to-use framework.

    Ben KingeryOxspring Paul
  • Customer story

    At Synchronous Customers, we need to connect various types of data quickly. The super handy ZappySys connectors and great documentation let us do it without writing a lot of code.

    Joel ConnerSynchronous Customers
  • Customer story

    I looked everywhere for a product that could integrate to a web portal backend API via JSON. After many attempts, ZappySys was the only solution that gave me all the options I needed in a quick & clean interface within SSIS.

    Maz DunicSave the Children Australia
  • Customer story

    We have worked with the ZappySys support team for over a year and have consistently found them extremely helpful — resourceful and creative in offering multiple solutions to our challenges.

    Senthil SekarPublicis Groupe
  • Trustpilot

    I’ve been using ZappySys for over 6 years — it makes development faster, and I introduced it to my current company.

    Anna JohnsonTrustpilot review
  • Trustpilot

    I’m integrating data from APIs into database tables with SSIS/ZappySys — very easy to use, fast, and highly efficient without writing complex code.

    Carolyn S.Trustpilot review
  • Customer quote

    I submitted a support request and had someone logged in and fixing things within 2 hours.

    Barry Wilson
  • Customer quote

    The REST source is very powerful — the only thing I found I could use after trying components from major vendors.

    Jes KirkupKTC
  • Customer quote

    Whenever we run into an obstacle, ZappySys has a solution for us. We are so glad that we chose ZappySys PowerPack.

    Kevin ChenBerricle

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.

New purchases may be eligible for refund review within 30 days. See the refund policy.

Talk to an engineer before or during your trial.

1 / 6