Using Dummy Data Source in SSIS


This article guides you through utilizing the Dummy Data Source in SSIS to populate tables with random data for testing purposes. You can check the component’s page here


  • SSIS PowerPack: Download and install the ZappySys SSIS PowerPack from this site.


  1. Drag and drop the Dummy Data Source component into the Data Flow.

  2. Select the columns for your test data in the Dummy Data Source settings. You can create new columns based on your requirements. Specify the number of rows you want in the output.

  3. Set the examples for columns, and specify the scale and precision needed for numeric column data types.

  4. Connect the Dummy Data Source to a destination component. In this example, a Trash Destination is used for demonstration, allowing you to enable the data viewer and inspect the generated data.


The Dummy Data Source in SSIS is a valuable tool for generating random data for testing and development. If you encounter any challenges or have specific use cases, please contact our support chat on our website.