Debugging in SSIS

Question

How do I debug the. NET code written in a SSIS package within a script task? The development environment allows a breakpoint to be set, but when debugging, it does not take me to the code as it would in regular. NET programming.

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

One thing I have worked out at the moment was using msgbox. But this is no replacement for full-fledged debugging using the environment of growth. We appreciate all the support. Thanks.

Answer 1

Within the BIDS environment debugging SSIS packages is not the same ball game as operating with Visual Studio.

If you have created your own custom framework, i.e. from within the visual studio, then you should be able to test the unique features of that component in the Visual Studio environment before making the component usable for use in the BIDS environment.

You can not modify the internal. NET code that makes up any of the other modules built into SSIS (i.e. the FTP task) inside BIDS, and I doubt that there will be any other custom component.

Check out Msbi certification training that enables you to master MSBI tools like SSIS, SSRS, and SSAS using SQL Server.