Debug SSIS Script Component

If you need to debug C# code in a SSIS Script Component inside a Data Flow, you’ll be dismayed that the breakpoints won’t work. You’ll need to run DebugView and put a line like this in your code:

System.Diagnostics.Trace.Write( “Here’s my debug message!” );

Get DebugView from Microsoft here:

http://technet.microsoft.com/en-us/sysinternals/bb896647.aspx