You can use precedence constraints to control which logical path an SSIS package follows. So...

Can you just scan the results of the queries by eye to determine which is behaving unexpectedly?

Once you know which query is returning the wrong results, it will be easier...

Yes - or maybe a better editor like Notepad++. Even better, MS Access.

I'll state my position on this, and I know I am not alone.

If you need to store and analyse hundreds of thousands of data rows, use a database.

If you want...

SinisterPenguin (7/25/2011)

---

I don't think you will find a tool to do this for you - you will just have to re-write the functionality of the package in T-SQL manually &...

It would also help if you would explain 'in English' what that expression does, rather than leaving it as SQL puzzle of the day, to help those here who do...

Is your source and target data all on the same SQL instance? If so, may I ask why you are using SSIS for this?

If a foreach loop has nothing to process, execution transfers to the next task. So I suspect that there is something in the logic of your package which is causing...

Please describe in more detail what you want to achieve.

Include an idea of what the data source and destination are - is this all in SQL Server?

Please ask a question, rather than leaving us to guess.

Your SQL query can do this using FOR XML PATH...

OK. Please answer my other questions and describe what you mean...

Is it always after exactly 4 hours?

Have you checked the event log?

Does the job fail?

Looks to me like a formula error.

What about

=Sum(Fields!TotalSales.Value)-Sum(Fields!Budget.Value)

?

Your formula is doing this:

134,648.44 - 63,530.00 = 71,118.44

Please include sample data and expected/desired results too.