Control Task

• nkm129

  SSCommitted

  Points: 1763

  More actions

  August 25, 2008 at 12:01 am

  #154652

  Hi,

  1) I have 10 server running and need to create a package which will run and see that server is up or not. If it is up then I need to transfer some data.

  Question :- Which control task can be used to check that server is running or not ?

  2) Which task from SSIS can be used to read error message from event log ?

  Thanks!

• Dave Klug

  SSCertifiable

  Points: 5811

  More actions

  August 26, 2008 at 6:24 am

  #863062

  There's an article here that may help... http://www.sqlservercentral.com/articles/Integration+Services/61714/