can dts "invert" data

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@.bla.com> wrote:
>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
>

can dts "invert" data

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, ChrisRImport 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@.bla.com> wrote:
>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
>