Post reply

Killing a package at runtime

  • May 29, 2012 at 3:57 am

    #258789

    Hi,

    We are having a SSIS package which is executed at 5.00AM. The package will look for the availability of the data (generally data is available in the source system by 5.30AM). After the availability of data it is pulled loaded into the destination.

    Requirement is , if there is no data available in source system then the package after waiting for 1 hr(say 6.00AM) should get terminated. This need to be implemented inside the package or the package is scheduled in SQLServer agent, so this should be implemented in the SQL server agent.

    Need your suggestion on how to approach it either in the package or in the Agent.

    Thanks

    Regards

    Jim

  • May 29, 2012 at 4:00 am

    #1494062

    Consider using a file watcher task with a timeout of 1 hour.

    You can configure the task such that a timeout results in a warning or an error.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • May 29, 2012 at 4:17 am

    #1494075

    Sorry forgot to mention the source. It is oracle database. I think File watcher will not work for oracle.

    Jim

  • May 29, 2012 at 9:59 am

    #1494258

    I would use a For Loop Container (FLC) to poll for data in Oracle using an Execute SQL Task and then sleep for n-seconds in between tries.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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