For loop with multiple stop conditions SSIS 2008

  • Hi, is it possible to make a for loop container where the eval expression has more than one condition?

    I want the for loop to keep looping if @Result != 1 or it is not yet 8:00AM.

    If Result == 1 before 8am then stop looping and take one path, if it gets to 8:00AM, stop and take another path.

    I hope this is possible.

    Thanks for reading,

    Howard

  • You can use multiple conditions seperated by ands and/or ors (no puns intended) as long as they combine to form one expression.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

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