Online Safety Community


SSIS includes two special tasks that enable you to query system information and monitor system events: the WMI Data Reader Task and the WMI Event Watcher Task. These tasks are especially useful for system management, as you will discover with examples later in External Management and WMI Task Implementation Topic. WMI uses a specialized query language known as WQL, which is similar to SQL, to obtain information about a Windows system. WMI has many features and capabilities, so we won’t be able to cover all of them, but here are a few common uses:

  • You can get information about files and directories, such as file size, or enumerate the files in a folder. You can also monitor the file system for events, such as whether a file has been modified recently. This could be required in a package if your package is importing data from a CSV or XML file. A change in the file could trigger tasks to fire in your package.
  • You can determine whether an application is currently running. In addition, you can find out how much memory that application is using or how much processor time it has used. This is useful if your package needs to know whether a companion process is running before creating some sort of output result.
  • You can obtain information about users in Active Directory, such as whether a user is active or has certain permissions to a resource. This is useful in a package if information about a user or machine on the network is required for your package’s execution.
  • You can control services that are running on a computer system and actually start and stop them as required. This is useful if your package needs to stop a service during a data transfer.

This is just a small sample of the information you can glean from a computer system. You can obtain information not only about the current system but also about remote systems. As you can see, this gives you access to a great deal of information that could be used in the execution of an SSIS package. For example, you could determine if enough disk space existed on a drive before copying a backup file from a remote system to the current system. You could also monitor a file for updates and automatically import the changes into a database table. Later in External Management and WMI Task Implementation Topic you will see how to actually implement these two examples. For more information on the WMI system, visit HTTP://MSDN.MICROSOFT.COM/ENUS/LIBRARY/WINDOWS/DESKTOP/AA394582(V=V....

Article Credits: Mindmajix

Views: 58

Reply to This

Take our poll!

Take our poll!

Latest Activity

Mark Nilson posted events
15 minutes ago
Training Doyens posted an event

Excel: Demystifying the Sort and Filter Tools. How to Easily Summarize & Analyze Complex Data. at 26468 E Walker Dr, Aurora, Colorado 80016

October 10, 2018 from 1pm to 2pm
OVERVIEWExcel is a powerful program for managing and analyzing lengthy lists of data. What tips, tricks, and techniques do you need to know to quickly and easily sort and filter a range or table of data? Join this training course to explore the shortcuts and solutions for effectively working with…See More
51 minutes ago
Carl Martens posted a blog post

The Basics Of Peer-To-Peer Recognition

Employees spend a great amount of time at work, perhaps sacrificing personal and family time, and they deserve to be recognized. Fifty-seven percent of companies that implemented a peer-to-peer recognition program saw a significant increase in employee engagement, leading to higher productivity and employee retention rates. The accompanying slideshow details the basics of peer-to-peer recognition and provides tips companies can use to easily implement and maintain such a program. The Basics of…See More
11 hours ago
Russel Stuart posted a blog post

Diversity in the Workplace is all About Embracing Differences

Diversity in the workplace brings different perspectives and thinking into the workplace. It helps employees learn to understand each other better and removes insularity.If there is one mantra that is most commonly associated with the modern workplace, it has to be diversity in the workplace. Diversity in the workplace has gained greater momentum in this age of globalization. World over, there is a tendency to accommodate multiculturalism through a diverse workplace. Diversity at the workplace…See More
18 hours ago


Workplace health and safety Signs 4 Replies

You cannot ignore the importance of safety signs at your workplace. There is no scope to underestimate the important to health and…Continue

Tags: Prohibition, Workplace, Warning, Signs, Safety

Started by healthandsafetysigns. Last reply by Jen McDade on Monday.

Jewellery policy - breakaway pins

Hello,Hopefully someone has come up against this, my employers have implemented a jewellery policy; its a bit over the top but they are keen on enforcing it.As is the tendency with anything…Continue

Tags: watches, heavy machinery, industry, Jewellery

Started by Brent Sep 10.

Secure Yourself From The Impending Danger 3 Replies

The most important thing in life is one’s protection against the impending dangers of life. While working or even at home we all feel the need to be safe because if we have good and safe life, only…Continue

Tags: coverings, Protective

Started by Enna Henry. Last reply by Jen McDade Sep 7.

How To Get The Safest Personal Protective Equipment? 2 Replies

Worried about the safety issues? Feeling a little concerned about the safety factors? Running a company and the safety problems are bothering you? Feel relaxed and look for the best safety solutions…Continue

Tags: equipment, protection, personal

Started by Enna Henry. Last reply by Jen McDade Aug 31.

Safety Books 1 Reply

Please view this brochure and let me know if you are ok with the condition before we can share full books of safety…Continue

Started by Binh, M.S, Grad.IOSH, MIIRSM. Last reply by Jen McDade Aug 31.



© 2018   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service