I'm using "Transfer Logins" task in SSIS package to copy SQL logins from one server to another. Some logins no longer exist in Active Directory and this is where my package breaks. How can I make my package ignore the errors and finish copying existent logins? Thank you in advance for your help! Leon
I am assuming if the logins no longer exist is Active Directory, then you can delete the user account/SID from the source SQL Server before you run the transfer task. Happy 4th!!! -- Ross Mistry - Author Windows Server 2008 Unleashed, SQL Server 2005 Management & Administration Look forward to my new book called SQL Server 2008 Management & Administration "Leon Shargorodsky" wrote: > I'm using "Transfer Logins" task in SSIS package to copy SQL logins from one > server to another. Some logins no longer exist in Active Directory and this > is where my package breaks. > How can I make my package ignore the errors and finish copying existent > logins? > > Thank you in advance for your help! > > Leon
