I'm new to DTS and bear with me please. I want to test the transformation when copy from table A to Table B. Table A has two column a & b in char and decimal respectively. In the transformation, I try to add 100 to column b using the code below, but I received a type mismatch problem. Table A and Table B have the same format!
Originally posted by rfarris
I think that your type mismatch could be that you are attempting to add the integer value of 100 to a decimal value stored in "b".
Thanks for your help, and I tried your suggestion but it does not help. If I change the field to real, it seems to be okay. The problem is I want to import a table from DB2 via ODBC and some of the fields are decimal. If I can only make it work by changing those fields to real, it is a lot of manual work to change the type.