Q:After migrating the MSDB database on the new server via restoring, DTS Packages cannot be opened and executed. An error message appears: The system cannot find the file specified
Simply copying or restoring data tables from an MSDB database on a new server does not allow to restore DTS Packages because they have interior connections to the execution context of the server on which they were created and on which they were used on it prior to migration. To copy DTS Packages between servers, VB scripts must be employed. Therefore, the program SQL Server Recovery Kit is not suitable for restoring DTS Packages.