DSXchange

Hi all,
Iam loading data from sqlserver to oracle using sqlserver stage and oracle enterprise stage. if the source having data in sqlserver there is no issue if there is no data its giving error"the call to sqlldr failed the return code = 1"
my target oracle option is load--append mode
can you please help me regarding this

Thanks

Unless someone else chimes in who knows better, I'd suggest you contact your official support provider and see if that is expected behaviour in that situation. You may need to 'test' your source first and only run the loader job if there is actual data to load.

I think that's just "how it works" - Oracle throws an error if you invoke sqlldr and provide a stream of 0 records. You should check first whether any records will be selected, and only execute the job if there are.

Have a look at this viewtopic.php?t=119030 and see if it is relevant to your situation (it may not be).

Thank you so much BillB. its working fine after adding of ENV

thank you all.