Post reply

Should the service be set to manual or automatic?

  • March 13, 2008 at 11:55 am

    #184955

    We recently set up a new cluster on our production environment for sql server 2005. The cluster is an active/passive Veritas cluster.

    Does anyone know if we should set the Integration Services service to manual or automatic?

    Thank you in advance.

    Jen

  • March 13, 2008 at 7:25 pm

    #789387

    If you are running scheduled SSIS jobs, you must have the SSIS service started on the server from which you run the jobs. If you run your packages manually, autostarting the SSIS service is optional.

    hth,

    Tim

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices

  • March 14, 2008 at 2:00 pm

    #789876

    Tim,

    Thank you for taking the time to respond. We currently don't have any scheduled SSIS jobs. My goal was just not to mess up the Veritas failover process by having a service in a start mode it should not be.

    So, I'll keep them in manual mode and turn them to automatic if we ever have scheduled SSIS jobs.

    Have a great weekend! 🙂

    Thanks!

    Jen

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply