DSXchange

I have made changes to job currently job is running fine but not sure when this random conversion error is going to popup. for now I'll close this post and open new if If I receive this error again. Thank you all for your time.

Thank You all, Currently I am using default conversions with out any valid checks. I will make the changes to job to use validity checks.

Hi, We are loading the data from seq file to SQL server table and getting the below error randomly when we run the job again after failure with out any changes this is going to run fine. I am not sure what could be the Issue. please some body let me know what could be the reason for this random erro...

Thanks Andy, I have changed job design to use connector stage.

Hi Arnd,
Thanks for reply, we are using DRS stage but not DRS connector stage. Sorry for not being clear in my post !!

Thank you craig and ray, I used user defined query as suggested by you.

Hi,
How to write a user defined query in ODBC stage, I know there is user defined option, Here are the details, I have A, B, C columns from the source link and I need to delete the records in target table having col X,Y Z, P, Q, R using where condition X =A and Y=B and Z<=C.

Thanks,
Rgr

ray.wurlod wrote:Is your expression missing If at its beginning? ...

No

Thanks,
RGR

Ray,
still I am getting same warning

ray.wurlod wrote:Start by disabling operator combination so you can see which stage is actually generating the error. It may not be where you think. ...

Thanks Ray,
I have disabled operation cobination it is showing in the same transformer
where Iam using above exp.

Thanks,
RGR

Hi, Iam using following exp IsNull(column_name) Then '' Else If Num(column_name)) Then column_name) Else 'aaa' the source data type is char. The above expression is working fine in server but in parallel Iam getting APT_CombinedOperatorController,1: Null string argument.warning, even I tried Using N...

Hi Monaz,
I am not sure but try this ('0000000000':Iconv(InLink.TheNumber, "MD2"))[10]


thanks,
rgr