SSIS Loop Expression not doing anything .. why?

• samalex

  SSCertifiable

  Points: 5429

  More actions

  December 19, 2014 at 2:45 pm

  #293241

  In SQL 2012 I have an SSIS package with a For Loop Container. In the SSIS Package I have a variable @LoopCount as an Int16. Within the Container I check some logic and if true run the following in a C# Script Task:

  int LoopCount = (int)Dts.Variables["User::LoopCount"].Value;

  Dts.Variables["User::LoopCount"].Value = LoopCount + 1;

  And for the Loop container I have this:

  InitExpression: @[User::LoopCount] = 0

  EvalExpression: @[User::LoopCount] > 0

  But when I run the package the loop never loops, just a green check with nothing within it executing. Even if my internal logic is screwy I'd think this would at least do an infinite loop, but it doesn't run even once.

  Thanks for any advice.

• ZZartin

  SSC-Dedicated

  Points: 30921

  More actions

  December 19, 2014 at 2:48 pm

  #1765810

  Shouldn't that be a >= 0 in the EvalExpression?