Data Generation and Anonymization are SSIS components that will create random sample data for various use cases.

There are currently two SSIS components that fall under this category. Data Spawner will generate sample data, which can be of great use when testing SSIS packages as it can quickly generate the exact kind of data that you need to test with, for you. The other, Data Anonymizer, will mask current data by generating sample data in its place.

The following are the data generation and anonymization components available within the SSIS Productivity Pack and the link to their Help Manuals:

Youtube Video - Getting started with SSIS Productivity Pack - Data Generation and Anonymization Components

  • Data Spawner
    • Generates random sample data with options to specify column names and spawn type, along with other necessary options.
  • Data Anonymizer
    • This SSIS component allows you to anonymize or mask sensitive data before moving it into another system. Developers select the columns they wish to mask and the anonymization type. The component will then generate random sample data based on the anonymization type.