Looping Back in a DTS Package

• HookSQLDBA7

  SSChampion

  Points: 10709

  More actions

  June 10, 2005 at 7:22 am

  #167163

  Is there any way to loop back to a previous step or task within a DTS Package? For example, using an ActiveX Script Task or Execute SQL Task to redirect the flow of a package based on the value of a Global Variable? Please provide me an example.

  Thanks in advance, Kevin

   

• DSP-120308

  Hall of Fame

  Points: 3959

  More actions

  June 10, 2005 at 7:55 am

  #564602

  This link should give you a good example of what you are trying to do.

  http://www.sqldts.com/default.aspx?246

   

  Good Luck,

  Darrell