Import ssis package into SQL server ie msdb after entering password from package creator.

Use Server security to simplify process.

Fix by restarting SQL Agent and reload SSIS package

Hi Lawrence , I am interested in automating restores to a reporting database on the same server. Can you post scripts please? How do you deal with adding users back...

Thanks Andy , this should be highlighted on this site It fixed my 21002 error with login (restored Db from Prod )

 This was saved.

  On win 2000 was an issue(mmc 1.4)

Resolved on Win XP using mmc 2.0

SQL 2000 SP3a fixes this error