Post reply

looping with DTS

  • 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

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply