Tuesday, March 5, 2013

Restart SSIS Service

If you need to check if the SSIS service is installed or if whether it's running or not.

If you need to know more about the SSIS service, let me refer you to this post...http://www.ssistalk.com/2009/11/04/ssis-what-does-the-ssis-service-actually-do-anyway/

Anyway...

You can pull the RUN command and type SERVICES.MSC and you'll get to the list of the locally installed services, or go to :
CONTROL PANEL --> ADMINISTRATIVE TOOLS --> SERVICES

Search for SQL server Integration Services, by clicking on S or scrolling down.

 
right click and you'll get all the options like START/RESTART/STOP.

Hope that helps!