it worked , the point is to put propagate at the dataflow level inside the foreach loop.

if you put propagate at the foreach level , errors coming from other tasks...

please note that - this is not to ignore the row , its actually to ignore the file itslef

this can only be achieved using tsql json functions only

I masked them , I work on medical data

your assumption was wrong - I was trying to hide medical data , make it simpler to understand for the forum

I wish , but thats not possible for now.

no problem - I think if you haven't worked on 837 EDI files , it might be difficult.

anyone else have some idea - please

Lets say we have sample 837 data below.

and as you know primarly it has:

2000A- Billing Provider

2000B- Subscriber

2000C- Client, though this is only on the form if it’s different than the...