Viewing 15 posts - 1,081 through 1,095 (of 3,232 total)
Rowan (8/21/2009)
John Rowan (8/20/2009)
A couple of things. First, I like you name! Secondly, all of the advice given here is spot on. One thing I'd like...
August 21, 2009 at 10:07 am
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.
August 20, 2009 at 5:01 pm
If you need an e-mail regardless of how many errors that are, you need to change the expression to be:
@[User::ErrorCount] > 0
August 20, 2009 at 4:56 pm
Your original post on this thread stated:
when ever there is an error upto 50 on a flat file it should send me an email
That tells me that you want...
August 20, 2009 at 4:51 pm
Thread continued here:
http://www.sqlservercentral.com/Forums/Topic774464-148-1.aspx
August 20, 2009 at 4:37 pm
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...
August 20, 2009 at 4:28 pm
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...
August 20, 2009 at 4:18 pm
The expression is working. Your error count is 495. That is more than 50 so you should not get an e-mail.
August 20, 2009 at 4:05 pm
Given the variable values, wouldn't you expect there to be no e-mail?
when ever there is an error upto 50 on a flat file it should send me an email,
I thought...
August 20, 2009 at 3:59 pm
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...
August 20, 2009 at 3:43 pm
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...
August 20, 2009 at 3:40 pm
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?
August 20, 2009 at 3:28 pm
My bad. || is OR. You need && for AND. Replace the pipes w/ && and you should be good.
August 20, 2009 at 3:10 pm
Your current expression will not do that. In that case, you'd want your expression to evaluate to True when error count > zero and error count 0 ||...
August 20, 2009 at 2:48 pm
Viewing 15 posts - 1,081 through 1,095 (of 3,232 total)