Post reply

Checking a table in different server using SSIS recurring scheduled job

  • October 9, 2008 at 12:34 pm

    #126962

    Hi All,

    I have a requirement to start my job only once the ready flag in a table becomes YES,If this was in the same serve i would have done this easily using recurring schedules for a job to check in every 5 mins into the table for the Ready flag value, but here the requirement says that I have to check for the ready flag in a different server table....

    I am not sure If I can use recurrence in a different server without any problems ?????

    or

    if I shud create a package to check this flag in different server????

    Do I need to use a linked server if I do it from a job using a TSQL statement...

    Please let me know as this is my first SSIS project...

    I am really confused...

    Any help is appreciated.

    Thanks

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • October 9, 2008 at 3:27 pm

    #883146

    You could use the ExecuteSQL task with a connection to the remote server. You load the value into a variable. If it is the right value then continue with the process.

    Russel Loski, MCSE Business Intelligence, Data Platform

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

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