How do I preserve legacy DTS packages in sql 2005 after uninstall/install

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Data Transformation Services (DTS) » How do I preserve legacy DTS packages in sql...

How do I preserve legacy DTS packages in sql 2005 after uninstall/install

Rate Topic

Display Mode

Topic Options

Author

Message

jdbrown239

Posted Friday, January 25, 2013 6:54 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:35 AM
Points: 112, Visits: 212

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

jdbrown239

Posted Tuesday, January 29, 2013 11:06 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:35 AM
Points: 112, Visits: 212

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

jdbrown239

Posted Tuesday, January 29, 2013 1:21 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:35 AM
Points: 112, Visits: 212

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 »

Permissions