MSBI (SSIS/SSRS/SSAS) Online Training

Tuesday, April 7, 2009

SSIS-How to copy DTS 2000 packages between servers( from SQL 2000 to SQL 2005 and SQL 2008)

Hi,
When upgrading DTS 2000 packages, we should make sure you move all relevant objects from database. You can use tasks in Integration Services to move most of these objects. However, DTS 2000 packages cannot be moved using the Integration Services tasks. Instead, you must manually move the contents sysdtspackage.
See the given below link for more details:
http://sqlcat.com/msdnmirror/archive/2009/03/20/remember-to-move-dts2000-packages-when-upgrading-msdb-from-2005-to-2008.aspx

No comments: