Select the variable that contains the values of the columns going downstream. Now, move to the Input Columns Tab. In this tab, select the columns that you want to shuffle. These columns are the ones in the source and will be mapped to the same set held in memory, using a library variable. They will shuffle as a monolithic tuple, so if you want to shuffle values in each column separately, you will have to repeat this process as many times as you want to shuffle columns. In the example below, the columns 0, 1, 2, and 5 will be shuffled together. In the next tab, map the input columns to the library variable columns, one to one: Make sure that column 0 matches column 0, column 1 matches column 1, etc. There will be masked columns created for each mapped column: The metadata will contain both unmasked and masked values: Configure your error output. There is a currently known bug where the null values are re-directed into error output out of which you can further merge them back to the pull. The ETA for bug to – be fixed is in the next release. Map values to their destination, and run the package. Mask Generic Shuffle component
Select the variable that contains the values of the columns going downstream. Now, move to the Input Columns Tab. In this tab, select the columns that you want to shuffle. These columns are the ones in the source and will be mapped to the same set held in memory, using a library variable. They will shuffle as a monolithic tuple, so if you want to shuffle values in each column separately, you will have to repeat this process as many times as you want to shuffle columns. In the example below, the columns 0, 1, 2, and 5 will be shuffled together. In the next tab, map the input columns to the library variable columns, one to one: Make sure that column 0 matches column 0, column 1 matches column 1, etc. There will be masked columns created for each mapped column: The metadata will contain both unmasked and masked values: Configure your error output. There is a currently known bug where the null values are re-directed into error output – out of which you can further merge them back to the pull. The ETA for bug to be fixed is in the next release. Map values to their destination, and run the package. Mask Generic Shuffle component
HUSH%20HUSH%20MASKING%20SSIS%20COMPONENTS%20MANUAL%201.8.1.docx