Post reply

Moving DTS packages from one server to another

  • April 15, 2009 at 8:06 am

    #130118

    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 teh package saving it and moving them to another server. This will be a time consuming task since i have more than 100 + packages.

    I appreciate your reply.

    Thanks

  • April 15, 2009 at 9:31 am

    #978178

    Use DTSBackup2000. It's free, it copies all the packages in an instance, and it's very reliable. I've used it many times. Find the download here:http://www.sqldts.com/242.aspx

    BTW, there is a DTS specific forum on this site. Click on 'Home' and look down the list.:-)

    Greg

  • April 15, 2009 at 9:58 am

    #978200

    Thanks greg

    I will post my clarifications regarding DTS over there. However i have one quick question is there any other way we can do this move without downloading third party s/w's?

    It would be great if you can tell me some steps to do this through SQL.

    Thanks and going forward i will post my DTS queries over DTS forum.

    Thanks again

  • April 15, 2009 at 10:37 am

    #978242

    INSERT INTO msdb.dbo.sysdtspackages

    SELECT *

    FROM OPENDATASOURCE('SQLNCLI','Data Source=ServerName;Integrated Security=SSPI').msdb.dbo.sysdtspackages

  • April 15, 2009 at 11:52 am

    #978291

    Adam's right, that's the way to copy packages using T-SQL. If packages have multiple versions, I'd probably check the createdate column to get the latest version.

    Greg

  • April 15, 2009 at 8:12 pm

    #978561

    Thanks Adam and greg

  • February 10, 2010 at 11:43 am

    #1117047

    Hy, in regards to this task, I work with SQL Server 2008 and want to copy the SSIS packages from one server to another. will this utility work with 2008 SSIS packages also? Or is there another way of doing it?

    ST

Viewing 7 posts - 1 through 6 (of 6 total)

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