Online Safety Community

Hello,

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: 31

Reply to This

Take our poll!

Take our poll!

Latest Activity

nicolewells posted a discussion

Security Storage SAN Performance

Hello All,Have a question regarding SAN performance specifically EMC VNX SAN. I have a significant number of processes spread over number of blade servers running concurrently. The number of processes is typically around 200. Each process loads 2 small files from storage, one 3KB one 30KB. There are millions (20) of files to be processed. The processes are running on Windows Server on VMWare. The way this was originally…See More
yesterday
Rebecca Lewis posted a discussion

What safety signs should I acquire for my shop’s construction?

Hello everyone! The construction of my new flower shop will start next month, and it’s a big project for me. Since the shop’s location is near the main road, I want to make sure that everyone is safe during the work. I can’t afford any accident like people getting injured. So I’m thinking of purchasing construction health and safety signs from a supplier that my friend recommended.…See More
Friday
Rebecca Lewis joined Safety Community's group
Thumbnail

Construction

For those working in Carpentry, Drywall, Electric, General Labor, HVAC, Landscaping, Masonry and Plumbing.
Friday
Adam Fleaming posted a blog post

FMEA in medical devices can work better when mated with ISO 14971

Failure Mode and Effects Analysis (FMEA) is a core aspect of risk management and risk analysis in medical devices. FMEA is essentially about analyzing the reasons for which a problem arises and the effects it has on the system. In the field of medical devices, it is absolutely critical to understand the failure mode and effects because the consequences of not doing this can be disastrous and many times, even…See More
Friday

Forum

Security Storage SAN Performance

Hello All,Have a question regarding SAN performance specifically EMC VNX SAN. I have a significant number of processes…Continue

Tags: san, vmware, emc

Started by nicolewells yesterday.

What safety signs should I acquire for my shop’s construction?

Hello everyone! The construction of my new flower shop will start next month, and it’s a big project for me. Since the shop’s location is near the main road, I want to make sure that everyone is safe…Continue

Started by Rebecca Lewis on Friday.

Gig Economy

The career world has rapidly changed and these days, long-term careers and people working in just one job are slowly but steadily becoming a thing of the past. In fact, according to research, in the…Continue

Tags: field, engineer, IT, freelance, economy

Started by Mohd Azher on Wednesday.

How to Repair MySQL InnoDB Table That Has Issues?

When trying to run: delete IdentityRequest *I get an error of sailpoint.tools.GeneralException: null index column for collection: sailpoint.object.IdentityRequest.itemsDoing a select * from…Continue

Tags: course, sailpointonline, sailpoint

Started by Soujanya Naganuri on Tuesday.

Occupational Health and Safety 7 Replies

Health and safety are important aspects of an organisation’s smooth and effective functioning.  Did you know that workplace health & safety injuries cost Australian businesses over $60 billion…Continue

Tags: Safety, and, Health, Occupational

Started by WHS Solutions. Last reply by Tony Ferraro Feb 18.

Badge

Loading…

© 2018   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service