Does this help?

SELECT ItemParam = T.c.value('Item[1]/@param', 'nvarchar(50)')
      ,ItemValue = T.c.value('Item[1]/@value', 'nchar(10)')
      ,DefaultRpx = T.c.value('DefaultRpx[1]/@value', 'nvarchar(40)')
FROM @XML.nodes('/SelectionCriteria') T(c);

I've tried everything I can think of and I can't figure it out, either!

Blimey....

Can you confirm the exact format of JObject? It looks like

{"View"true,"Edit"true,"Admin"true}

Is that right?

OK, weird. If you run the package manually from SSISDB, by right click and Execute, does the problem still occur?

You mean exactly the same rows are selected and ignored every time?

I had checked the data.

When I run the ssis package via SSIS package it runs without any issues.

But the same package I am running, its not getting the full...

I suggest you identify the 10 missing rows and look for something that differentiates them from the 9 that make it. Also confirm that the data source and target are...

OK, please provide a couple of examples, along with the desired result.

Just to be clear, you are comparing the values of two parameters, is that right? Because you also mention 'fields', and it's not clear whether you mean values in a...

Ok, this actually works I must have run the wrong query 🙂

But, why "mx" and "mn" and what does the WITH function dos in this case?

I suppose it's max...

Another version.

WITH mx
AS (SELECT TOP (1)
           Dsc = 'Max Vacation Hours'
      ...

That will give you the same result twice. There is another solution, hopefully someone else will provide it as I am going to be busy for a while. By the...

Maybe this?

Select TOP (1) 'Max Vacation Hours', * 
From [HumanResources].[Employee]
ORDER BY vacationhours DESC

Union

Select TOP (1) 'Min Vacation Hours', * 
From [HumanResources].[Employee]
ORDER BY vacationhours

If you are looking for sympathy. poor you!

If you want help resolving the error, please post the problematic query...