How to load a flat text file with packed decimal field to a sql table

[sam]

i have this flat text file that has a number of packed decimal
field type. How do I load that text file into a sql table.

thanks

[MAK]

1. Load the text file using DTS. Import the text file into a table with Varchar/char as column type.
2. Create another column with numeric datatype.
3. Unpack the decimal and update the numeric column.- Example for how to unpack
http://www.peoplesoftfans.com/psfans/forum/interface/messages/141.html
4. remove the varchar/char column.

-MAK


------------
sam at 4/3/01 9:09:56 AM


i have this flat text file that has a number of packed decimal
field type. How do I load that text file into a sql table.

thanks

do i have to unpack it.

is there a way (bulk copy) just loaded with a
different field datatype.

thanks
------------
MAK at 4/3/01 10:33:50 AM

1. Load the text file using DTS. Import the text file into a table with Varchar/char as column type.
2. Create another column with numeric datatype.
3. Unpack the decimal and update the numeric column.- Example for how to unpack
http://www.peoplesoftfans.com/psfans/forum/interface/messages/141.html
4. remove the varchar/char column.

-MAK


------------
sam at 4/3/01 9:09:56 AM


i have this flat text file that has a number of packed decimal
field type. How do I load that text file into a sql table.

thanks

do i have to unpack it.

is there a way (bulk copy) just loaded with a
different field datatype.

thanks
------------
MAK at 4/3/01 10:33:50 AM

1. Load the text file using DTS. Import the text file into a table with Varchar/char as column type.
2. Create another column with numeric datatype.
3. Unpack the decimal and update the numeric column.- Example for how to unpack
http://www.peoplesoftfans.com/psfans/forum/interface/messages/141.html
4. remove the varchar/char column.

-MAK


------------
sam at 4/3/01 9:09:56 AM


i have this flat text file that has a number of packed decimal
field type. How do I load that text file into a sql table.

thanks

[MAK]

i dont think SQL had Packed decimal datatype.
Secondly if u wanna manipulate the data then u need to unpack it.

Good luck
-MAK



------------
at 4/4/01 11:14:26 AM

do i have to unpack it.

is there a way (bulk copy) just loaded with a
different field datatype.

thanks
------------
MAK at 4/3/01 10:33:50 AM

1. Load the text file using DTS. Import the text file into a table with Varchar/char as column type.
2. Create another column with numeric datatype.
3. Unpack the decimal and update the numeric column.- Example for how to unpack
http://www.peoplesoftfans.com/psfans/forum/interface/messages/141.html
4. remove the varchar/char column.

-MAK


------------
sam at 4/3/01 9:09:56 AM


i have this flat text file that has a number of packed decimal
field type. How do I load that text file into a sql table.

thanks