Looping steps in DTS - 2 steps waiting causes error

• Jonathon Williams

  SSC Veteran

  Points: 261

  More actions

  July 30, 2007 at 3:45 pm

  #197124

  I keep getting an error since I am setting two steps waiting (one the active task i'm on and the other the one i have to back to in the loop). 

  How do I loop back to task 3 and keep the task i'm on waiting?

  Thanks

  mathjon

  *******************CODE*******************

  Function Main()

   Dim oRS

   Set oRS = DTSGlobalVariables("rs_US").Value

   ' Check if there are still more records in the Recordset

   If oRS.EOF Then

    ' No more records, so continue workflow

                             Set  DTSGlobalVariables("rs_US").Value = Nothing

    Main = DTSTaskExecResult_Success

   Else

    ' More records to process, so loop back and do not execute this task

    DTSGlobalVariables.Parent. _

     Steps("DTSStep_DTSExecuteSQLTask_3"). _

     ExecutionStatus = DTSStepExecStat_Waiting

    Main = DTSStepExecStat_Waiting

   End If

   Set oRS = Nothing

  End Function

• Jez-448386

  SSCarpal Tunnel

  Points: 4594

  More actions

  July 31, 2007 at 6:32 am

  #723542

  Have a look at this:  http://www.sqldts.com/246.aspx

  It might be as simple as setting the execution status of the current step to success:

  Main = DTSTaskExecResult_Success

   

  You have yours set to waiting.

   

  J