My source is Oracle 9i and target is Sql Server 2005.
My job is oracledatabasestage -> transformer -> odbcstage.
Previously job is running perfectly, now I got one new file is PMNEXTDUEDATE in that one I am getting nulls also. So in source I specified Nullable is yes and in target also I specified Nullable is yes
and I wrote derivation for that file like this:
Code: Select all
If IsNull(Into_Trns.PMNEXTDUEDATE) = 1 then '1900-01-01 00:00:00' Else If len(trim(Into_Trns.PMNEXTDUEDATE)) = 0 then '1900-01-01 00:00:00' Else Into_Trns.PMNEXTDUEDATE
My source contains 1,200,000 records if I excute job after 400,000 records the job is going to abort. I am gettting fatal error like INVALID Julian day" if I wrote derivation for that filed like this '1900-01-01 00:00:00' then all records loading
Thanks in Advance