It appears to me as the broken login problem. Once you restore a database, the database users and logins are probably not been mapped properly.

Can you tell me what...

SQL server DTS Packages can be saved in 3 different places:

1) In the SQL Server (Not Necessarily in the same server, could be in a different server too; of course...