I know something like this was addressed before on this forum but I am unable to locate it at all....
Anyone know the solution ?

Problem :

After you move databases to a new server, users may not be able to log in to the new server:

Used DTS ...

Thanks..

checkout sp_change_users_login in BOL

sp_change_users_login [ @Action = ] 'action'
[ , [ @UserNamePattern = ] 'user' ]
[ , [ @LoginName = ] 'login' ]
[ , [ @Password = ] 'password' ]