I'm validating all of the facts in our Data warehouse after all packages are finished.
In a separate package I query the Source and DWH and compare the results to eachother. This check does work for all of the facts accept for the last one loaded. It seems like SSIS is reporting the package to be finished, but SQL Server is still busy updating
the table, so when I query the DWH at that time I do not get a full result.
This only happens when packages are ran by the SQL Server Agent. When running SSIS in Debug mode I don't have this problem (probably beacause it is so much slower).
Is there a way to solve this? (Other then scheduling the check at a later time?)
Thnaks in advance!
View Complete Post