I came across a very strange behaviour in DTS in SQL Server 2000 (it has SP4
but I don't know if it's relevant). After I added all the columns as source
columns in a transformation task's Options -> Source Columns tab (whether one
by one or all at once), the column order is completely reversed (instead of
COL001, COL002... it lists COL019, COL018...). The problem is I have been
using ordinal to access the columns and it gave me the order that is listed
in that window.

I have at least 3 other packages that are done this way without any problem
but this is the only one that exhibited this behaviour, anyone clue?