As I've noted before, we have clients who send us data files, and I've been
putting together an SSIS package to read each file (same fields and stuff)
into staging. Using an expression in the connection string has proven to
work very well.

However, I've hit a snag. While all the files have the same fields in them,
they don't necessarily have them in the same order. So the piece ID and
location ID may come in that order, or they may be reversed, but they'll be
there.

DTS in SQL2K handled this automatically, but I'm having problems finding the
proper setup in SSIS. Anyone have any insight?