• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

WMI (windows Management Instrumentation) Data reader task

WMI  Data reader task

It is used to read the Data about a system using WMI Query language

 

Steps to Configure WMI Data reader task

Open Business Intelligence Development studio      ———–>

Create a new package and Rename it as WMI Data reader task .dtsx      ———–>

In control How drag and drop WMI data reader task      ———–>

Double click on it to configure and set
WMI Connection  — New Connection      ———–>

Check Windows authentication check box      ———–>

Click text to evaluate the connection      ———–>

Click ok

WQL Query source Type – Direct input default

WQL Query source          — Select name, star Mode form Win 32 – Service

Destination Type                              — File connection (default)

Destination                                         — New connection      ———–>

Create File      ———–>

Click Browse      ———–>

Provide file name as WIN 32 – service details .csv      ———–>

Click open      ———–>

Click Ok

Interested in mastering MSBI Training? Enroll now for FREE demo on Online MSBI Training.

 

Example WMI queries:

Below query used to display the installed soft wares list from Microsoft Manufacturer

Select * from Win 32  — Pn P entity, where

Manufacturer = Microsoft

 

Deployed project (SSIS) to integration services server:

In BIDS select “project Menu” and select properties (last option)      ———–>

Select deployment utility and set create deployment utility – true deployment output path   — bin / deployment           ———–>

In solution explorer select project and right click      ———–>

Select Rebuild      ———–>

Open windows Explorer and navigate to the project go to bin folder and go to deployment folder, select integration services deployment manifest file with name as project [Morning 8:30]      ———–>

Select Manifest file and right click and select deployee      ———–>

In welcome to the package installation wizard      ———–>

Click next      ———–>

Check file system deployment radio button and also check validate packages after installation check box      ———–>

Learn more about MSBI Interview Questions in this blog post.

Click next      ———–>

Click next      ———–>

Click next      ———–>

Click finish      ———–>

Open SSMS

 

Connect to integration services Expand stored packages and also expand file system you would observe that the morning 8:30 project deployed to server.

For an Indepth knowledge on MSBI click on:

Summary
Review Date
Reviewed Item
WMI (windows Management Instrumentation) Data reader task
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on WMI (windows Management Instrumentation) Data reader task"

Leave a Message

Your email address will not be published. Required fields are marked *

Site Disclaimer, Copyright © 2016 - All Rights Reserved.