Time Limit on Package

[Azzuri]

Hi,

Is there a way to stop a DTS package if it takes too long. I want it to stop after 25 minutes. I was hoping there is a time limit option on the packages. Any help is appreciated.

Thanks,

 

[JayKusch]

One way may be to check this link out and see if you can rework it to meet your needs.

http://www.sqldts.com/default.aspx?251

Another method, a bit cludgy though, may be to call the DTS package from a job. You could then follow the same procedure I listed for another used w/in this post ...

thread962-937523


Thanks

J. Kusch