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.


Use Products

GO

Select top 5 * from Products

GO

Pages: 1 2 3




Related Articles :

Uncategorized

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 |