Error while running job

[Roopanwita]

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.

[georgesebastian]

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

[DSguru2B]

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

[Roopanwita]

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.