I want to implement something like the following:
In this package, I want to loop through a list of database names, dynamically modifying connection manager settings.
However, the first failure on "Test Connection" will halt and fail the package execution.
But I'd like to continue my Foreach loop. I get the sense that this should be possible (otherwise what's the use case for these red failure arrows?)
Things I've tried include messing with "MaximumErrorCount".

Asked by Michael J Swart
(2235 rep)
Oct 7, 2014, 02:22 PM
Last activity: Apr 1, 2024, 11:39 PM
Last activity: Apr 1, 2024, 11:39 PM