I recently migrated a number of DTS pacakages from a SQL 2000 server to a new
SQL 2005 SP1 server. SQL 2005 resides on a new box and was not setup using
the default instance.

The problem I am having is that DTS packages that were moved over using the
Migration Wizard when viewed using BIDS the output columns are reversed.
This does not appear to be a problem for simple migrated packages, straight
table dumps. The packages I am having an issue with use SQL command to
define the columns to dump and their order. WHen the data is viewed with in
the source the column layout is correct. WHen you view the column mapping on
the destination (flat file output) the columns reverse. Anyone have a idea
how to get around this?