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:
Post a Comment