Transfer Logins Task
The Transfer Logins task allows you to copy logins from the source SQL Server instance to the destination SQL Server instance. You can choose to transfer all the logins on the server or the selected servers or all the logins for the selected databases. The following steps let you configure this task on the Designer panel:
1. | Open the editor window for the task to configure. Then specify a name and description in the General page. |
2. | You can specify most of your settings in the Logins page. Specify a SourceConnection and DestinationConnection to connect to source and destination servers using the SMO Connection Manager in the Connections section. |
3. | In the Logins section, choose from the three options to specify the logging ... |
Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
