Post reply

Migrating a 2005 dts package to 2005

  • July 10, 2015 at 12:42 pm

    #398728

    How do you move a DTS package stored in a SQL 2005 MSDB DB to another SQL 2005 instance? Yes, upgrading may be a better solution but in the immediate term we're migrating everything on our Windows 2003 Servers to newly installed SQL 2005 instances on Windows 2006 R2 servers.

    Dan

  • July 10, 2015 at 12:49 pm

    #1811738

    This article might help you:

    https://www.virtualobjectives.com.au/sqlserver/dts_sql2005.htm

    I hope that you already have the DTS Designer Components installed.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

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

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