Execute Package in Loop
Hi I have to Re-Execute Pacakge on Error. So, i did as below. On Task Failure -- > Call Execute Package "PackageLoop" on the "PackageLoop", I have called Execute Package "PacakageMain" I am getting error Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.ShanmugaRaj
September 14th, 2012 6:44am

as mention in the error msg , change the "MaximumErrorCount" to >1 OR better run the same package ONERROR tab (Event handler) --Let us TRY this | My Blog :: http://quest4gen.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
September 14th, 2012 6:56am

On a separate note, try and use the sql server agent job to orchestrate your packages if the only thing you want to do is execute different packages on error and on success. This makes it more flexible to changes in future.http://btsbee.wordpress.com/
September 14th, 2012 7:06am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics