Records are getting rejected
Posted: Wed Jul 14, 2010 9:12 pm
hi,
my job design is 2 datasets------>join--------->Transformer---------->oracle
totally ihave 29 columns to insert.if i used 28 columns its going fine,whenever i used that 29th column then records are getting rejected.its nullable column.
so i hard coded that column with value which is coming from source that time also its rejected,now i removed some data from that column then its inserted.below are the used logics and hardcoded values
this logic i have used in the job
If (IsNull(lk_trim_trans.doc_notes)) Then TrimLeadingTrailing(lk_trim_trans.doc_notes) Else TrimLeadingTrailin(lk_trim_trans.doc_notes)
if i use above logic records are getting rejected.
source value is
'Index 18472 Sheet Ref 03.05.10; http://www.vishakaexp.co.in/Publication ... 05031020/0;'
now also its rejected
i have modified like this
'Index 18472 Sheet Ref 03.05.10; http://www.vishakaexp.co.in/Publications/2010/03/;'
now its inserted.
Could anyone please help me to sortout this issue.Thanks in advance.
my job design is 2 datasets------>join--------->Transformer---------->oracle
totally ihave 29 columns to insert.if i used 28 columns its going fine,whenever i used that 29th column then records are getting rejected.its nullable column.
so i hard coded that column with value which is coming from source that time also its rejected,now i removed some data from that column then its inserted.below are the used logics and hardcoded values
this logic i have used in the job
If (IsNull(lk_trim_trans.doc_notes)) Then TrimLeadingTrailing(lk_trim_trans.doc_notes) Else TrimLeadingTrailin(lk_trim_trans.doc_notes)
if i use above logic records are getting rejected.
source value is
'Index 18472 Sheet Ref 03.05.10; http://www.vishakaexp.co.in/Publication ... 05031020/0;'
now also its rejected
i have modified like this
'Index 18472 Sheet Ref 03.05.10; http://www.vishakaexp.co.in/Publications/2010/03/;'
now its inserted.
Could anyone please help me to sortout this issue.Thanks in advance.