Viewing 14 posts - 46 through 59 (of 59 total)
Make sure you name the resultet 0 (that's zero)
October 23, 2007 at 4:23 am
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...
October 23, 2007 at 4:19 am
Looks like a typical scenario to use the lookup transformation task.
See BOL
October 23, 2007 at 3:43 am
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
October 23, 2007 at 3:34 am
Did you install the fix in the following article?
March 30, 2007 at 2:07 am
Looks like the bug described in the following KB article:
March 19, 2007 at 3:10 am
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)
March 14, 2007 at 8:06 am
Sorry I got confused with the ISNULL function in SSIS. Both functions will work.
March 13, 2007 at 3:35 am
The ISNULL function might not work. A better option will be Coalesce:
LEFT OUTER JOIN TRADE_ALLOCATION TA
ON TR
March 13, 2007 at 3:17 am
Try this expression in a table footer:
=Sum(IIF(Fields!Accountgroup = "Cost Of Goods Sold" , per_net_amount, 0)
- Sum(IIF(Fields!Accountgroup = "Operating expenses" , per_net_amount, 0)
March 12, 2007 at 4:31 am
You have a few options here:
March 12, 2007 at 4:16 am
Detach/Attach will do the job. On a logical level nothing will change. Encryption keys don't have to be restored since you don't change the RS-service
March 7, 2007 at 6:56 am
To show only the date in a textbox, right click the textbox in the layout tab and click properties.
On the format tab Type "d" in the format code textbox and...
March 6, 2007 at 8:49 am
The account the sql server agent is running under should have all permissions necessary to run the IS package. Check all your connections and check whether the agent-account has permission.
March 6, 2007 at 8:20 am
Viewing 14 posts - 46 through 59 (of 59 total)