Using WMI Data Reader and WMI Event Watcher Tasks in SSIS


12.   Finally to complete the example we will connect the WMI Event Watcher and WMI Data Reader tasks  , and then Group these two tasks together by right clicking both task and selecting Group   from the drop down list, and renaming the group as WMI Tasks as shown in the snippet below.

 

13.  Execute the package by right clicking the WMITasks.dtsx package from the Solution Explorer and then select Execute Package option from the drop down list.

14.  Once the package execution has begun you can copy and paste a trigger file (empty file) for example “Execute_WMI_Data_Reader_Task.txt” in “D:Package” folder.

15.  Once the WMI Event Watcher Task identifies the newly created file it passes the control to the WMI Data Reader Task which gets the list of all the running windows services on the local machine. Once the package has successfully executed you will be able to see the below screen within the control flow designer.

Conclusion

In this article you have seen how to configure and use the WMI Event Watcher and WMI Data Reader Tasks which is available in SQL Server Integration Services.

Pages: 1 2 3




Related Articles :

  • No Related Articles Found

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 |