WITH mx
AS (SELECT TOP (1)
           VacationHours = 'Max_Hours'
         ...

You are using terminology which is confusing me.

There are no variables in my code. Zero.

Nor is there a 'header' called Max_VacationHours.

The second you put, "Min_VacationHours", but doesn't bring it.

No I...

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...