sql server dts: I'm writing a DTS custom transform that is to take a Packed Decimal
field from a file, unpack it, and then insert it into a sql server
table. So the source for my transform is a file and my target is
SQLServer. The transform is working and works fine with the source as
a character field an the target as a character field (DBTYPE_STR
sqlserver VARCHAR ). However, if I change my target column to a
decimal field (DEICMAL(8,2)) the column type is still reported to the
ProcessPhase as a DBTYPE_STR. No problem, I thought it must do the
conversion to decimal from the text. Nope I get a NULL value into my
column in SQL server. However, the PreValidation function reports the
decimal column as DBTYPE_NUMERIC. There is not a single example of a
DTS Custom Transform that I can find that targets anything other than
a string field. So how in the world do I do this ? I presume its not
pretty since there are no examples of it.

Regards,

Never mind, I've figured it out. Apparently when you test a transform
the target columns are always character sinve the results go into a
grid control. When you actually execute the package the trasform gets