Transfer Logins Task and Transfer Database Task in SSIS

10.   Connect the Transfer Logins Task, Transfer Database Task and
Execute SQL Task as shown in the snippet below.

11.  
Finally, execute the package by right clicking the TransferLoginsAndDatabasesTask.dtsx
package from the Solution Explorer and select the Execute Package option from
the drop down list. Once the package has successfully executed you will be able
to see the below screen within the control flow designer.

12.  
Once the package has executed successfully execute the below TSQL
to verify the data in Products table of Northwind database.

Use Northwind

GO

Select top 5 * from
Products

GO

Conclusion

In this
article you have seen how to configure and use the Transfer Logins Task and the Transfer Database Task which are available in SQL Server 2005
Integration Services and later versions.

Pages: 1 2 3




Array

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |