How to Split Rows into Multiple CSV Files Using SSIS and ZappySys PowerPack

Introduction

In this tutorial, we’ll guide you on splitting rows from a source into multiple CSV files using ZappySys SSIS PowerPack. This process is useful when managing large datasets by splitting them into smaller files.

Prerequisites

• SSIS installed
• Download and install ZappySys SSIS PowerPack

Steps

1. Add a Data Flow Task to your package.
2. Configure a JSON Source with 500 rows (Example 4).
3. Set up a CSV Destination and define the file path.
4. Choose FileSplitMode: Rows or Size.
5. Set the MaxSizePerFile (for size) or MaxRowsPerFile (for rows) properties.
6. Configure the Input Columns and run the package.

Result

You’ll now see multiple CSV files with the specified number of rows or file size.

👉 Read the full tutorial here with detailed steps and screenshots