Hi Guys,
There was a requirement to run the SSIS package again and again even after failure. ( SAP connection should wait for infinite time). I was able to achieve this by setting the "For loop" task and "Data Flow Task" Event handler's "Propagate" variable to False. This I could achieve by following the steps in the below link.
http://gqbi.wordpress.com/2013/06/27/ssis-stopping-an-error-from-propagating-to-its-parent-enabling-an-ssis-package-to-continue-when-an-error-happens/
This could be achieved in another way (but I don't know if this is advisable)
Set the "ForceExecutonResukt" property of the SSIS package, For loop and Data Flow task to "Success" This also produces the same result.
There was a requirement to run the SSIS package again and again even after failure. ( SAP connection should wait for infinite time). I was able to achieve this by setting the "For loop" task and "Data Flow Task" Event handler's "Propagate" variable to False. This I could achieve by following the steps in the below link.
http://gqbi.wordpress.com/2013/06/27/ssis-stopping-an-error-from-propagating-to-its-parent-enabling-an-ssis-package-to-continue-when-an-error-happens/
This could be achieved in another way (but I don't know if this is advisable)
Set the "ForceExecutonResukt" property of the SSIS package, For loop and Data Flow task to "Success" This also produces the same result.
No comments:
Post a Comment