sql2k sp3a

Dont know if "invert" is the right word, but the only one I could come up
with. I have a flat file that displays data like:

GEN_PROREGCTCTXT CRZCODE S_GENERATION
1 CB 1
1 CS 1

That top row is data, not column names FYI. Anyways, what I need to do is
get that file into a table but I need it accross, not down. Meaning that the
rows 2 and 3 from column 1 will actually go into columns 2 and 3 in row 1.
It needs to look like:

GEN_PROREGCTCTXT 1 1
CRZCODE CB CS
S_GENERATION 1 1

Is there a way for DTS to handle something like this? Another good way to do
it?

TIA, ChrisR

Import it into SQLServer the way it is, then look up how to code a
"pivot" query to turn it over.

J.


On Thu, 25 Aug 2005 13:28:50 -0700, "ChrisR" <noemail (AT) bla (DOT) com> wrote: