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


SSIS: Suggested best practices and naming conventions

http://consultingblogs.emc.com/jamiethomson/archive/2006/01/05/SSIS_3A00_-Suggested-Best-Practices-and-naming-conventions.aspx