How to break out of For Each Loop

• sqldba-121678

  SSC Enthusiast

  Points: 127

  More actions

  October 26, 2006 at 8:09 am

  #115239

  I have a package that uses a For Each Loop ( For Each File enumerator ) to import all the files in a directory into my database.  I want to be able to set a configurable value that will limit how many files will be imported at a time.  How can I best modify my package to break out of the loop when I reach my configured number of files?  I don't want to end the package, I just want to break out of the loop. 

• Jim Dillon-291542

  Hall of Fame

  Points: 3344

  More actions

  October 27, 2006 at 9:27 am

  #668536

  You could use a while loop and a counter something like

  DECLARE @counter1 int

  DECLARE @total_count1 int

  SET @counter1 = 1

  SET @total_count1 = N

  WHILE @counter1 < = @total_count1

  BEGIN

  "CODE HERE"

  SET @counter1 = (@counter1 + 1)

  END

  I hope this helps,

  jim

• sqldba-121678

  SSC Enthusiast

  Points: 127

  More actions

  October 27, 2006 at 9:36 am

  #668540

  The problem lies in the For Each File Loop.  I don't see how I can implement any kind of counter without ditching my existing For Each File loop.