Post reply

Export DTS

  • September 12, 2005 at 8:11 am

    #66895

    Hi everybody,
    I have many DTS packages on an old SQL 7 server and I would like to export them to a newer server with SQL 2000.

    Each DTS is importing data from DB2 to SQL and each package has complexe transformation behind it.

    Is there a way to exports this packages so that nothing gets lost? Including transformation & DTS ID?
     
    Thank you in advance

  • September 12, 2005 at 10:39 am

    #589117

    There are lots of ways to move packages and how much work you have to do depends on how the packages are written.

    To move the packages to a new server you can open each package and "save as" to the new server, "save as" a structured storage file or vb file, which can be moved to the new server and saved, or use a popular utility from dts.com called DTS Backup 2000 (http://www.sqldts.com/default.aspx?242).

    Once the packages are moved, you'll need to ensure that the DB2 ODBC driver and datasource are on the new server and you may need to change the connections for the destination database.

    Here's a collection of DTS articles on SSC: http://www.sqlservercentral.com/articles/articleList.asp?categoryid=28

    You should check out the articles about portable DTS packages and moving multiple packages.

    Greg

    Greg

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

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