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.

:blush: I forgot there was one. Yep, that should work. Not sure how performance compares with Unpivot in T-SQL, so staging might still be best if there is lots of...

Ah indeed. I just assumed that this would not be SQL Server to SQL Server, I admit.

John Mitchell-245523 (7/14/2011)

---

If you only ever will have the three account types, then you can do this in the code:

INSERT INTO MTable (Account_Code, Account-type)

SELECT Account_Code,

CASE LEFT(Account_Code,1)

WHEN '1' THEN...

Are all the inserts going into the same table?

asranantha (7/14/2011)

---

hi friends,

plese solve this and send my mail id =asranantha@gmail.com

...