Moving DTS Packages From 7.0 To 2K

  • Our SQL Server 7.0 ( NT 4.0 SP ) will be upgraded to Win2k and SQL Server 2k.

    It will be a clean install of SQL Server 2k.

    How can I move about 150 exisitng DTS packages (both local and Metadata)

    created in 7.0 to the SQL Server 2k box?

  • The only ways I know are to upgrade in place on the same server or save all packages as structured storage files.  Unfortunately, you can't restore a backup of a v7.0 msdb on a v2000 installation.

    Greg

    Greg

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

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