Viewing 15 posts - 31 through 45 (of 146 total)
I think you are confused, see this screnshot, i havent put any value on email expression so i wont get any email.
August 20, 2009 at 4:14 pm
Yes you are correct I need to send an email when ever error occurs from 1-50, on 0 error no email.
I didnt undertand what you were trying to explain ...
August 20, 2009 at 4:03 pm
Yes i verified with && and no email is sent when there are errors upto 50, and even i debug with toggle breakpoints, weird is that watch1 window is disabled....
August 20, 2009 at 3:37 pm
I tested with && also, and weird part is that it doesnt send any email on both condition? and on || it will send email on both condition.
August 20, 2009 at 3:17 pm
well i tested with the new expression, it will send an email even if there are o errors.
August 20, 2009 at 2:57 pm
I got you but my question is that suppose while loading a data i just get one error, and my max condition is same upto 50, do I get an...
August 20, 2009 at 2:42 pm
ya i change errorcount>=maxcount on expression and it worked.
August 20, 2009 at 2:30 pm
I have a short question what if I get 20 errors, in this senario also i need to get an email. does it work with that expression since i need...
August 20, 2009 at 2:29 pm
Yes i did as per your recomendation, I have attached the file, so what should i do next?
August 20, 2009 at 1:43 pm
Sorry I have no idea how to set up breakpoint in mail task and I am relatively new to ssis so i am just doing what i am understanding from...
August 20, 2009 at 1:20 pm
Here I have attached scren shot, there are 3 screnshots. I have created 3 variables, errorrowcount,ident and maxcount, and put maxcoun have value to 50,.let me know if you have...
August 20, 2009 at 12:57 pm
http://support.microsoft.com/kb/906547
I was using above link while confugring email task
August 20, 2009 at 12:23 pm
Ya i did that, but I dont know where i screwed up, i am getiing an email evertime the package executes.
August 20, 2009 at 12:17 pm
Viewing 15 posts - 31 through 45 (of 146 total)