views:

46

answers:

2

The debugging experience in SSIS is not what I am expecting.

I have a script Task that I have added a Imports System.Diagnostics' at the header of the class, and in the code I have various debug.writeline ("Attemtpting to move file") type messages.

But, they are not displaying in the output window.

Am I missing something ?

+2  A: 

How to: Debug a Package by Setting Breakpoints on a Task or a Container

Debugging Control Flow

Breakpoints in SQL Server 2005 Integration Services SSIS

Watching variables in SSIS during debug - Stack Overflow

To capture Debug.WriteLine output, download and run the standalone DebugView

Mitch Wheat
Thanks for those. Any articles on using debug.writeline ?
cometbill
+2  A: 

Use Dts.Events.FireInformation instead.

Todd McDermid
good call Todd. You can also use Dts.Log() but viewing this is slightly more cumbersome
JasonHorner