Restart package automatically

Hi there,

I would like to be able to automatically restart a package if it fails with a certain error. This is due to a job that fails every now and then due to a loss in connectivity to the database (when run again no issues).

I know how to catch the message, but is there i way that i can in a script task or some other task restart the whole package when moving into the OnError event for the whole package.

I know this isn't a great way to do it, but its just temporary until we can isolate the network issue that is causing the loss in connectivity.

Thanks

[603 byte] By [pimmy21] at [2007-12-24]