DECLARE @Rank TABLE(row_id int, pageview_id int, adv_id int)

INSERT INTO @Rank

SELECT 23454, 45324, 23 UNION ALL

SELECT 23455, 45324, 56 UNION ALL

SELECT 23456, 45324, 84 UNION ALL

SELECT 23457, 45325, 56 UNION ALL

SELECT...

Rowan (8/21/2009)

---

John Rowan (8/20/2009)

---

Rowan,

A couple of things. First, I like you name! Secondly, all of the advice given here is spot on. One thing I'd like...

Glad to help.

Yes. If the expression evaluates to True, the e-mail task will run. The expression will evaluate to True any time there are more than 0 errors.

If you need an e-mail regardless of how many errors that are, you need to change the expression to be:

@[User::ErrorCount] > 0

Your original post on this thread stated:

That tells me that you want...

Thread continued here:

http://www.sqlservercentral.com/Forums/Topic774464-148-1.aspx

Here's a recap on what we just did:

1. We tested the expression @[User::ErrorCount] > 0 && @[User::ErrorCount] <= @[User::MaxCount]

2. You said it was not working and you didn't get...

No, you set a breakpoint on that task. That prevents it from running until you tell SSIS to continue. If you exit debugging mode, the task will never...

The expression is working. Your error count is 495. That is more than 50 so you should not get an e-mail.

Given the variable values, wouldn't you expect there to be no e-mail?

I thought...

Its disabled because the package thinks it is finished. It will never make it to the breakpoint if the expression does not evaluate to true.

Remove the expression...

First of all, you don't need a cursor for this. Secondly, what determines the order? Is it the Adv_ID value or the IDENTITY column?

This should get you started:

DECLARE...

So you ran it with && and verified that your error count variable was between 0 and 50? Did you use the debugging mode to verify the variable values?

My bad. || is OR. You need && for AND. Replace the pipes w/ && and you should be good.