January 15, 2015 at 10:20 am
I have some Legacy DTS packages in a SQL Server 2005 Instance that I have export\imported into a SQL Server 2008 Instance.
The packages are working - however - when I did the export (from sql server 2005) and import (into sql server 2008) It only brought over the latest VERSION of each package.
I have read that you can bring the DTS packages over simply by importing the rows from dbo.sysdtspackages from one server to the other.
Does this sound feasible? I don't have a sandbox to test this in and I am wondering if anyone else has any suggestions for bringing the DTS packages forward to the new server - including all versions of each package.
January 15, 2015 at 10:27 am
Yes, it is possible. I have done this in the past and it works.
-- Gianluca Sartori
January 15, 2015 at 10:42 am
so if I backup the dbo.sysdtspackages on my sql server 2008 instance before replacing the rows with the contents of the dbo.sysdtspackages on the SQL Server 2005 instance - I could back this out if there is a problem?
January 15, 2015 at 10:53 am
I'm pretty sure it's safe. Back up the whole database to be sure.
-- Gianluca Sartori
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply