I am asking to see what I am doing wrong.
I am trying to Convert or Cast from Varchar to Decimal while I am doing DTS, and am constantly getting this error:
" Error converting data type varchar to numeric."
Currently, I have this data mode:
1) FROM Staging table:
varchar / length 3
2) TO Production table:
decimal / length 5 / Precision 3, Scale 0
I used this syntex to covert such as:
INSERT INTO tableB
CAST( FieldNameA AS decimal(3,0))
I know SQL's Book on line mentions as Implicit conversion, and so this is the reason that it should automatically convert, but I don't have any clue
what to do at this moment.
Appreciate for any feedback.