Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How do I preserve legacy DTS packages in sql 2005 after uninstall/install Expand / Collapse
Author
Message
Posted Friday, January 25, 2013 6:54 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 4, 2014 8:05 AM
Points: 133, Visits: 283
Hi
I have to uninstall sql server 2005 enterprise edition and then install sql server 2005 standard edition. I have 74 legacy dts packages in the instance. I would like to know the best method of importing the packages back after I install the standard edition.
Post #1411696
Posted Tuesday, January 29, 2013 11:06 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 4, 2014 8:05 AM
Points: 133, Visits: 283
This link answered my questions.
http://blogs.msdn.com/b/psssql/archive/2009/02/19/how-to-copy-dts-2000-packages-between-servers-and-from-sql-2000-to-sql-2005-and-sql-2008.aspx
Post #1413203
Posted Tuesday, January 29, 2013 1:21 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 4, 2014 8:05 AM
Points: 133, Visits: 283
I have been to that link when I first moved the packages but I got the answer I needed from this link, Thanks
http://msdn.microsoft.com/en-us/library/ms143706(SQL.90).aspx
Post #1413305
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse