SSIS in 2005

• Maverick100877

  SSCertifiable

  Points: 5240

  More actions

  December 7, 2006 at 12:19 am

  #175561

  Hi

  We have a Cluster sql server 2005. Now the problem is that everyday at a fixed time we get an alert in the MOM that the Sql Server Inegration Services have gone from Unknown to Stopped. Now I'm not able to find any error in the  event log.

  Also I'm very new Sql server 2005 so have not much idea as to how do I troubleshoot it.

  How do I go about investigating and troubleshooting it.

   

   

• December 11, 2006 at 8:00 am

  This was removed by the editor as SPAM

• MohammedU

  SSCoach

  Points: 19644

  More actions

  December 11, 2006 at 11:55 am

  #677291

  I believe it should write to system log because it is a service...

  Check status of SSIS in SQL CONFIGURATION MANAGER when it says stopped.

  You can use the following to check the status and send the email if it is not running...

  master.dbo.xp_servicecontrol 'QueryState', 'MSDTSSERVER'

   

  MohammedU
  Microsoft SQL Server MVP