adam, our last posts crossed...

I need to automate it because I have a log shipped server with multiple databases, log shipping in both directions. I might need to fail over one database or all of them... so I would prefer to have the jobs scripted out so I can recreate the ones I need easily, as opposed to having them actually being loaded onto the standby server.

I could bever get the transfer job task to work in DTS, does it actually work in SSIS?