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.
Error while running job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 125
- Joined: Mon Sep 11, 2006 4:22 am
- Location: India
-
- Participant
- Posts: 83
- Joined: Tue Dec 19, 2006 8:38 am
Re: Error while running job
Hi,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.
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
-
- Participant
- Posts: 125
- Joined: Mon Sep 11, 2006 4:22 am
- Location: India
i have checked the lenngth and datatype and not using any st
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.
2.I am not using any stagevariable in my job still it is giving problem.