SQL Server BI step with step SSIS 6

SSIS is not only an ETL tool, but it's very powerful. Take its WMI data Reader task and the event watcher task to get even a lot of information about the operating system. Windows Management Specification (Windows Management Instrumentation) is one of the top secrets in Windows. WMI uses WQL queries to complete the following applications:

1. Read the System event log to find a specific error

2. Query running list of applications

3. Query how much memory can be debugged during package execution

4. Determine the free disk space on the disk

Of course, these applications can also be implemented using C # calling WMI. With SSIS, however, you can combine these applications with database operations, data transformation, and integration to play a more powerful role.

Demand:

Need to obtain the disk free space size of the remote server.

Realize:

1. The first thing to determine is that querying the size of the remote computer's disk must have administrator privileges on the host or be able to run the package as an administrator.

2. Create a new SSIS package with the name Wmi_query, add the WMI data Reader task in the control flow, and double-click the attribute to set the period:

Wmiconnection directly to the new link, enter the host name, username and password, of course, here also can be dynamic connection, so need to directly change the Wmiconnection connection string.