Post reply

When there is no exception, then no email notification.(set up an expression condition for executing next step)

  • May 18, 2010 at 2:06 pm

    #139082

    I have a table called excpetions, and there is a column called name_id, and created something so that when the count for name_id is 0, then the next step email notification would not send out.

  • May 18, 2010 at 2:14 pm

    #1169092

    Sorry if I am missing it but was there a question in there?

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • May 18, 2010 at 3:00 pm

    #1169124

    The question is how to program it?

    Thanks,

    Qjlee

  • May 18, 2010 at 3:03 pm

    #1169126

    In ssis you would have a script task that write it's result to a variable. Then in you flow one of the flows would be an expression. Take one path if the variable is >0 and one path if the variable is <1.

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • May 18, 2010 at 6:26 pm

    #1169178

    How to specify if the result is >= 1 one path and the result is = 0 another path.

    Thanks,

    Qjlee

  • May 19, 2010 at 7:02 am

    #1169397

    I usually do something like <1 or >0

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply