SQL Server 2019 Azure.
I have a basic fact load package that someone has tagged an execute sql object onto the end of that updates various fields in a fact table.
when I run the whole package, 2 out of the 6 columns do not update and when selecting from the table, they appear as null.
If I execute only the sql task on its own, it updates 3 rows.
In all my years of SSIS, I have never seen anything like this happen.
Can anyone think what may be causing it?
I appreciate its hard without seeing the package however the fact it works in isolation should be enough to prove the SQL is sound.
There are also no conditions on whether the object executes or not and anyway 4 out of 6 columns do update so it is obviously executing.
All ideas gratefully received.