debug ssis package - reload InnerPackage.dtsx

Question

Hi all,

I used the wizard to build a package that loops through my tables does whatever. It has worked forever and now I have to change it. How on earth do I debug this thing? When I try to run it from bids, it opens InnerPackage.dtsx for editing and then asks me if I want to reload it (since it has changed since the last iteration of the loop). I can't press yes or no fast enough to prevent the package from failing because 'process cannot access the file because it is being used by another process'. How can I keep this from opening so that I can get to the point that it's actually failing when the server runs the package and fix it. Many thanks.

Answer 1

Put a Breakpoint on it, or on the step before it.

Alternatively, you may need to copy the package, then open it with BIDS Helper and regenerate all of the IDs (GUIDs). (BIDs helper can do this in one step for you).

Answer 2

The wizard uses some behind the scenes "magic" to do it's work that makes it really difficult to debug. You might be best off recreating the package yourself. More work, but you can debug it much more easily.