YOu can't do the sum in a pivot by itself. However, you could do pre-aggregation in a CTE or subquery then pivot the results. That might just do it...

You're getting the opposite results because the dialog sets the conditions under which the element is hidden. So, you're saying, "If I have some rows, hide the element" ...

Just wondering if anyone has come up with a solution to this problem....

Unfortunately, since...

John Mitchell-245523 (12/30/2013)

---

How about the InteractiveMode variable?

Indicates whether the package is run in interactive mode. If a package is running in SSIS Designer, this property is set to True. If...

John Mitchell-245523 (12/30/2013)

---

Presumably you run the debugger on a PC during development, but the package will run on a server in production? If that's the case, you can test...

I think I figured it out:

for boolean variables, a numeric value of 0 is equivalent to False. Any other numeric value is equivalent to True. You can also...

Koen Verbeeck (12/9/2013)

---

Step 7 is normal. Once you open the connection editor, the password is removed.

Which configuration did you use in step 10? Remember that the password is not saved...

Love those windowing functions! Here's a silly example:

select one,two, ROW_NUMBER() over(order by two desc) as rn

from (values (1,2),(1,4),(1,6)) vals(one,two)

I noticed the examples in the book for creating a Numbers table. Of course they all work fine! I would like to contribute a variant that I happen...

pietlinden (12/2/2013)

---

Open the report in design view.

Right-click a column, show properties.

Click on the Visibility tab.

When the report is initially run HIDE

Display can be toggled by this report item (choose a...

quote]Koen Verbeeck (11/28/2013)

---

What if you rewrite the query?

DECLARE @Input INT = ?;

SELECT @Input;

Also make sure the property ByPassPrepare is set to True.[/quote]

Now, that makes sense. ByPassPrepare did the trick...

More info on this:

From http://technet.microsoft.com/en-us/library/cc280502.aspx

quote:

--------------------------------------------------------------------------------

SELECT, INSERT, UPDATE, and DELETE commands frequently include WHERE clauses to specify filters that define the conditions each row in the source tables must meet to...