SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 How to find out if SSIS is installed or not
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

14 Posts

Posted - 04/24/2013 :  12:01:20  Show Profile  Reply with Quote
In my company there are 500 SQL servers; how can I find out if SSIS is installed or not on those servers? I want to list out the servers who has SSIS installed on it. I dont want to do it manually going in one by one each server. Is there a scipt I can use/make? Can it be done using policy based management? any idea would be appriciated.

Thank you,

Very Important crosS Applying yaK Herder

52326 Posts

Posted - 04/24/2013 :  12:41:16  Show Profile  Reply with Quote
you can use powershell for that

see Get-Service function


another way is to use DMV sys.dm_server_services


SQL Server MVP
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3865 Posts

Posted - 04/24/2013 :  15:47:44  Show Profile  Reply with Quote
I think dm_server_services lists information about only SQL Server, Full-Text, and SQL Server Agent services.

Powershell is ideally suited for doing what you want to do - i.e., traverse through several remote servers. The name of the Integration Service is MsDtsServ100 (or similar). So a simple Powershell script such as Get-Service | where-object {$_.name -like "MsDtsServ*" } would get you the info about the service (including whether it is running etc.) on each machine.
Go to Top of Page

Starting Member

14 Posts

Posted - 04/24/2013 :  17:06:22  Show Profile  Reply with Quote
I have used powershell and it worked. Thank you Visakh and James!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000