SSIS ForEach Loop -- How do you find what information is stored in a particular index
I'm starting to build SSIS packages and I can't seem to find on MSDN or BOL about what is stored at a particular index in the variable mappings section of the control. Does anyone know where there is a reference, or do you have to setup lots of tests where you check what is outputted to a variable from index 0..n? Thanks!
The way I follow variable values is in the debugger. First I set a valid default into the variable so that I won't get errors. Then I watch it as it proceeds. I don't know a better way, and I would invite anyone to comment on it, but is considerably better than when there was no debugger. There are better ways being invented all the time. In the ancient days, before debuggers were any good, we set up snapshot outputs. The order and value of the output would tell us what was going on.