While using a mapping variable for Dynamic Data Flow in Data Flow Task Plus, how can I block data from moving from source table to destination unless specifically mapped.

While using a mapping variable for Dynamic Data Flow in Data Flow Task Plus, how can I block data from moving from source table to destination unless specifically mapped.

If you don’t want a source column to be mapped to a destination column, you have to provide empty source column mapping, like the following :

 

ClientKey=

VendorKey=