posted 8/12/2011 by kylewalker - Views: [3588]
I ran into a small problem this morning when trying to test an SSIS package. I simply wanted to add a breakpoint to a Foreach Loop Container to pause the package at the beginning of each iteration of the loop. Pretty straight forward, yes? Well I thought so too. And what made this case all the more confusing is that I had done testing on the same package the day before and I was able to add the breakpoint with no issues. So here's what happened. I right-clicked on the Foreach Loop and clicked Edit Breakpoints... Applied the breakpoint to the beginning of each iteration of the loop and hit OK. And that's when this error popped up.
This wasn't an error I was familiar with at all and I wasn't able to find much help on the internet. But it turns that the loop just got corrupted. So if you see this error all you will have to do is delete the loop and recreate it. You may also want to delete and recreate any tasks that are inside the loop as well.