Post reply

Control Flow Task (Urgent)

  • August 26, 2008 at 2:48 am

    #211647

    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!

  • August 26, 2008 at 5:16 am

    #863015

    I don't know about the second one, but I think you need to write some SQL code to "ping" the server or do a simple select statement on a small table. Use that in an Execute SQL task to see if the server is running. Obviously, if you can't connect, then it's not. @=)

    You can set the ResultSet of the Execute SQL Task as a variable and use the "Success & Expression" part of the precedence constraint to evaluate whether or not to move on to the next task.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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