Previously I have discussed the dynamic column mapping using script component. Now, I am going to mention one more way of dynamic column mapping in SSIS. Let’s say, our source table is Table_1: ID    JAN    FEB    MAR 1    100    200    300 2    400    500    600 3    700    800    900 We want to map its columns dynamically in data flow task. First, u need to create a DTS … More Dynamic Column Mapping in SSIS : Part 2 (using dts variable)