Debugging in SSIS

Question

How do I debug .NET code written within a script task in a SSIS package? The development environment allows placing a breakpoint however does not take me to the code like it would in regular .NET programming while debugging.

Also, I am at a loss to understand how to add the SSIS package variables to the debug watch window?

Currently one thing I figured was the use of msgbox. But thats no substitute to a full fledged debugging using the development environment. Any help is appreciated. Thanks.

Answer 1

Note: If you are running on x64 you must change the project (SSIS) Debug propertie Run64BitRuntime to false.

After that you'll be able to debug a script task in .net, and break code in the script.

By the way John Sansom dont appear to have read this part of the question: How do I debug .NET code written within a script task in a SSIS package? Its a script task, not normal SSIS debugging.

Hope this helps.

Answer 2

Debugging SSIS packages within the BIDS environment is not the same ball game as working with Visual Studio.

You may find it useful to consult the reference Debugging How-To-Topics(SSIS)

If you have developed your very own custom component, i.e. from within visual studio, then you should be able to debug the specific functionality of that component within the Visual Studio environment, prior to making the component available for use within BIDS.

You are not able to debug the internal .NET code that makes up any of the other built in SSIS components (i.e. the FTP Task) within BIDS so I doubt a custom component will be any different.