I have an SSIS package that executes the Transfer Database process (copy). Whenever it executes, it's removes all the settings for db role and the permissions to the views that were designated in the source db for one particular LOGIN / User. How can I ensure that this does not happen anymore when the package is executed? Thanks for help!! Clayp56
Seems like the specific LOGIN/user does not exist on the destination, OR if exists than may be the mapping is not correct. Consider using SSIS Transfer Login task prior to Transfer database task. Here is a detailed [example] :
http://www.sql-server-performance.com/2009/transfer-logins-transfer-database-task-ssis/ Moreover, `sp_change_users_login` could be another option depending upon the nature of the Login (sql login) and environment.