WMI (windows Management Instrumentation) Data reader task

Blog Author


Published Date

21st September, 2018




  • Share this blog :

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:

About Author


Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .

Related Blogs

Write For Us