SSIS Breakpoint and other debug problems

Symptoms:

• When you add a or remove breakpoint from a breakpoint, the breakpoints of other tasks in other packages also change
• SSIS ignores breakpoints or breaks unexpectedly during debug
• Tasks execute unexpectedly during debug

Cause:

Duplicate Task Ids

When a package is created by copying another package, all the object IDs will be identical to the original package's IDs. This confuses visual studio with symptoms as described.

Resolution:

Install BIDS Helper if you haven't already, and use Reset GUIDs.