Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 How to find out if SSIS is installed or not

Author  Topic 

devenoza
Starting Member

14 Posts

Posted - 2013-04-24 : 12:01:20
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,
Dev

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-04-24 : 12:41:16
you can use powershell for that

see Get-Service function

http://technet.microsoft.com/en-us/library/ee176858.aspx


another way is to use DMV sys.dm_server_services

http://visakhm.blogspot.in/2012/04/retrieve-status-of-sql-server-services.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-04-24 : 15:47:44
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

devenoza
Starting Member

14 Posts

Posted - 2013-04-24 : 17:06:22
I have used powershell and it worked. Thank you Visakh and James!
Go to Top of Page
   

- Advertisement -