I'm making a data transformation of about 20 columns from one table to
another. I can't see anything that is triggering it, but it seems
that after I save and open the "properties" for the column order they
are all reversed!!!!

It's enough work to have to do it all manually once, but to have the
associations show up in reverse order is pissing me off.

Thanks,
Dave

Is this done on the automapping?
Is it the source and destination that are doing this?
What version + SP of SQL Server are you using?
What are your source and destination providers?




Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
www.konesans.com - for all your consultancy needs

This is not on automapping. The destination was getting messed. My
providers were SQL Server DBs. I basically just changed from using a
"Copy Column" Type transformation to a "ActiveX Script" which does the
same thing but allows me to edit the code to what I want.

Seems to fix it.