Post reply

Moving DTS packages from one SQL server 2000 to another SQL 2000 server

  • April 15, 2009 at 10:00 am

    #199458

    Hi

    Anyone have an idea how to move all the DTS package from one server to another.

    i.e.

    I have more than 100 plus of DTS packages available in one server . The server version is SQL 2000. Now we are going to move all the DB's and everything to another box it is also SQL2000. can anyone tell me how to move all the DTS packages in oneshot rather than opening the package saving it and moving them to another server. This will be a time consuming task since i have more than 100 + packages.

    However is that can be done without using any third party tool. Since i cannot use any third party tool. If this can be done through SQL itself that would be great.

    However i got reply from Greg but it was by using an third party tool. Whereas i cannot use nay third party tool in my server.

    Need help

    Thanks

  • April 15, 2009 at 11:54 am

    #978293

    More replies in the original thread: http://www.sqlservercentral.com/Forums/Topic697546-146-1.aspx

    Greg

  • April 15, 2009 at 8:09 pm

    #978559

    Thanks Greg

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

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