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. One will generate sample data which can be of great use will testing SSIS packages as it can quickly generate the exact kind of data that you need to test with for you. The other 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, 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. Develops select the columns they wish to mask and the anonymization type. The component will them generate random sample data based on the anonymization type.