June 16, 2005 at 2:38 pm
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
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy