Hi All,
I am executing some SSIS Packages using my Console application, Like MethodA calls MethodB, the MethodB calls execute Package, MethodA loops MethodB for multiple packages.
But I want to exit out of the MethodB if it is taking like more than 30 minutes to execute.
The execution flow in my application is Main calls MethodA, MethodA calls MethodB for multiple times each time for a package, I want to check how long the MethodB is taking to execute the Package if its taking more than 30 minutes I want to exit from it but want to continue with remaining Packages in the loop, so as I need to continue with it. Any help is much appreciated.
Any code snippet, a link or even a suggestion would be greatly helpful. Thanks in advance my friends.
What I have tried:
Searching online asking friends and colleagues and trying different options and executing it.