Killing a package at runtime

Question

Post reply

Killing a package at runtime

Jim1234

SSC Eights!

Points: 889
More actions
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

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

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

Phil Parkin SSC Guru Points: 245813 More actions · Answer 1

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.

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.