Moving DTS Packages

  • Hi All,

    what is the easy/quick way to move multiple DTS packages from one server to another server?

    any suggestions/solution greatly appreciated

    Regards!

  • Hi Shwetha,

    Do U wanna deploy the DTS packages from one Sever to other ? OR

    Do you wanna move the DTS packages (Code ) from one Server to other?

     

    If it is deploy you can just generate the self code from it and deploy using manifest on the other Server.

    If it is move the code, you just need to copy the solution files on the other Server.

     

    Cheers....-Deeps

  • Hi Pradeep, thanks for you response....yea I want to move a bunch of packages from server A to server B, if it were a couple I would copy/move using save as option or if server B had no packages/jobs I would have restored the msdb of server A to server B but this is not the case...

    I was wondering if there's a quick and easy way to move or copy all the packages from server A to server B.

    How would I generate the code?what are solution files and manifest?.....I'm really not familiar with it, I apprecaite if you can explain a bit - thanks again

    Regards!

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

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