Tag Archives: SSIS

Access SSIS variables in script task and script component

You have to write codes to access the variables in these two components in a slight different way. For Script Task: DTS.Variables[“VariableName”].Value For Script Component: Variables.VariableName Don’t forget to add these variables in task editor first. 🙂 Advertisements

Posted in SSIS (SQL Server Integration Service) | Tagged , , | Leave a comment

Cursor Using Foreach Ado Enumerator in SSIS

Recently, I have been trying to make a cursor using SSIS components and came up with this idea. The trick is explained below: Let’s say, we have a record set and we need to loop through the records to concatenate/append … Continue reading

Posted in SSIS (SQL Server Integration Service) | Tagged , , , , | 9 Comments

Dynamic Column Mapping in SSIS : Part 2 (using dts variable)

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 … Continue reading

Posted in SSIS (SQL Server Integration Service) | Tagged , , , , | 24 Comments