Polling to check for an existance of a record

  • I need to check every 15 minutes for the existence of a record in a table for the current date.

    So I would need to have a Stored Procedure that outputs the record count to a variable.

    Once the record is found the package completes as successful.

    I have been searching the internet for a similar solution.

    Has anyone done something like this?

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • Welsh Corgi (9/15/2014)


    I need to check every 15 minutes for the existence of a record in a table for the current date.

    So I would need to have a Stored Procedure that outputs the record count to a variable.

    Once the record is found the package completes as successful.

    I have been searching the internet for a similar solution.

    Has anyone done something like this?

    Which part of this is giving you trouble?

    Why bother with a stored proc for this? Sounds like a one-line ExecSQL-task-to-SSIS-variable followed by appropriate precedence constraints.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • I got it to work.

    A SSIS Script task worked.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

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

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