Using Transfer SQL Server Objects Task and Execute SQL Tasks in SSIS
9. Finally, execute the package by right clicking the TransferSQLServerObjectsTask.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.
10. Once the package has executed successfully, execute the below TSQL to verify the data in Products table of Northwind database.
Select top 5 * from Products