looping with DTS

• Dan Wing

  Newbie

  Points: 5

  More actions

  June 16, 2005 at 2:38 pm

  #167499

  I have a set of data transformations that I would like to perform twice (2 passes). I would like to change the source and target servers between the first and second pass.

  I have found a looping example on SQLDTS.com, but haven't had a lot of luck using it. Is there a better way than to set the ExecutionStatus of the next task to process?

   

  Thanks,

  Dan

• Paul Smith-221741

  SSCrazy

  Points: 2003

  More actions

  June 17, 2005 at 2:12 am

  #566331

  Eaiest way I know is to run it as 2 job steps passing a parameter to the DTSRun Command in each and then change the server ID's depening on the parameter.