Skipping Invalid XML files

dataservices job design
1

Hi All,

I am trying to design try and catch to skip invalid xml files (Faulty elements/Repetition elements–Circular level is 0).

Job Design:

Try --> xml --> Query–> Table --> catch (xml errors).

Issue is it job hit with an invalid xml, Complete ETL is failing instead of moving to next file in the filelist.

Please let me know if any one have implemented skipping invalid xmls.

Thanks.

dstage2006 (BOB member since 2017-02-15)