I have some data that I would like to use DTS to import to a MS SQL Server
table. Two of the fields contain packed-decimal data. Does an easy way exist
to transform the fields into unpacked (signed) decimal during the import? Can
anyone please point me to some documentation that would give some idea as to
how to proceed. I guess I could write a COBOL program to do the conversion,
but would like to be able to do it directly as the data is imported. My
thinking is that it would require the use of a VB script to do the
transformation? Any pointers on what that script might contain?

--
Thanks, Mike.

Yep

To get from packed decimal to unpacked values you could use an Active Script
transform as there is no built in function to do this I know of.




--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Mike Vanecek" <MikeV99 (AT) privacy (DOT) net> wrote