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. 🙂
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 one after another in a sequential manner. For example, you have 6 records: A B … More Cursor Using Foreach Ado Enumerator in SSIS
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)
