DSXchange

Hi,
My job layout Source-> Transformer-> Target. I have 1:1 mapping for maximum columns(from source to target) and for other columns I am passing default value(Empty String for Varchar/Char n 0 for int n dec).
Both source and target column length are Proper( In max cases both are same n in some case I have trimmed n made proper ).
But while running job it is giving error Too many digits in integer or decimal constant..
Both source and target data type n length i have made same.
Plz let me know how i can solve the problem.
Thanks in advance.

Roopanwita wrote:Hi,
My job layout Source-> Transformer-> Target. I have 1:1 mapping for maximum columns(from source to target) and for other columns I am passing default value(Empty String for Varchar/Char n 0 for int n dec).
Both source and target column length are Proper( In max cases both are same n in some case I have trimmed n made proper ).
But while running job it is giving error Too many digits in integer or decimal constant..
Both source and target data type n length i have made same.
Plz let me know how i can solve the problem.
Thanks in advance.

Hi,

I think this is a problem with the mismatch in length of metadata and the data.
how many rows are there in your source file?
Try to run with 5 rows first and check whats happining.

Thanks
George

Are you using any stage variables of type int or decimal? If yes, what is the Initial value that you have specified?

1.In my job i have checked the lenngth and datatype of all input and output columns,both are in proper synchronization (for mismatch of datatype between source and target I have changed datatype using function).
2.I am not using any stagevariable in my job still it is giving problem.