Make sure you name the resultet 0 (that's zero)

Hope this will help:

Create a new Execute SQL task as the first task in the control flow.

Sqlstatement: Select count(*) .......(rest of your query)..

Reslutset: Single row

Link the resultset to a new...

Looks like a typical scenario to use the lookup transformation task.

See BOL

Use a For Each Loop container using a variable. Use this variable in the flat file connection.

See tutorial in BOL: Creating a Simple ETL Package---Lesson 2: Adding looping

Did you install the fix in the following article?

http://support.microsoft.com/kb/899761

Looks like the bug described in the following KB article:

http://support.microsoft.com/kb/909369/en-us

Sorry, I made an error in the expressions. Try these:

=Sum(IIF(Fields!Accountgroup.Value = "Cost Of Goods Sold" , per_net_amount, 0)

- Sum(IIF(Fields!Accountgroup.Value = "Operating expenses" , per_net_amount, 0)

Sorry I got confused with the ISNULL function in SSIS. Both functions will work.

The ISNULL function might not work. A better option will be Coalesce:

LEFT OUTER JOIN TRADE_ALLOCATION TA

  ON TR