SSIS tip: Export and split SQL Server data to multiple CSV

SSIS Tips
,
1

Introduction

This tutorial explains how to split data exported from SQL Server into multiple CSV files using the ZappySys SSIS Export CSV File Task. Splitting files is useful when handling large datasets or when you need separate files for specific groups or categories, such as country, region, or customer.

Prerequisites

Steps

  1. In your SSIS package, go to the Control Flow tab and drag the ZappySys Export CSV File Task from the toolbox.

    Drag and drop task
    Drag and drop task528×299 21.4 KB

  2. Open the task and configure or create a connection manager for your SQL Server instance.

  3. Enter the SQL query that selects the data you want to export, or pick a table from the database.

    Select table
    Select table718×595 49.9 KB

  4. On the Target tab, specify the output folder path. The task can automatically generate file names if only the folder path is given.

  5. Enable Overwrite target file(s) if you want to replace any existing files.

    Select destination folder path
    Select destination folder path718×595 31.3 KB

  6. Open the Split Options tab and check Split by size/rows.

  7. Choose whether to split by size or rows, and enter the value that defines the limit.

  8. Optionally, use the Group by column option to create one or more files for each unique value in the selected column.

  9. Save the configuration and close the editor.

    Split options
    Split options718×595 32.9 KB

  10. Save and run the SSIS package.

  11. The following example shows results when splitting by 100 rows and grouping by the Discount column. Each unique discount value produces one or more files, each containing up to 100 rows.

    Final result 1
    Final result 1704×284 24.3 KB

  12. If you skip the Group by column option, files will be generated in sequence, each with the defined maximum row count.

    Final Result 2
    Final Result 2704×206 17.5 KB

Conclusion

The SSIS Export CSV File Task provides a straightforward way to split SQL Server data into multiple CSV files. You can control file size or row count and optionally split by a column value, which is helpful for creating grouped datasets or segmented exports. This makes it easier to manage and distribute data in smaller, structured files.

Visit our official page to start building smarter, faster, and more scalable solutions with ZappySys.

References

Contact us

If you encounter any issues or have specific questions, reach out to our support team via live chat or support ticket using our email support@zappysys.com.