Ordering columns when iterating over them in BIML script
I have a framework which uses BIML meta definition files with <tables><table><column> definitions in and then some package emitting BIML that this structure gets fed into.
My problem is that I'm adding a HASHBYTES based checksum to the packages. Getting it to generate the script transform task code in the packages is kind of ok but I'm using some code (a sproc) in the dest DB to generate the HASHBYTES statement for my testing rig. The sproc in the DB orders the columns for the table alphabetically but I can't figure out how to do this in the loops I have in the Package emitting BIML.
The order seems to be the order of the cols as they are listed in the generated BIML meta data definition. I could try and fix that I suppose but it feels a bit like a crummy workaround cos I'm missing something obvious in the c# (my c# is best described as rudimentary)
I have tried duplicating the list and then ordering the duplicate then trying to use the original index to then access the original object but am obviously doing something major stupid as this is just spinning its wheels and the actual ordre of the emit doesn't seem to be any different.
Can anyone point me at anything I can read up that will point me in the right direction.