debugging SSIS packages - debug.writeline

Question

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?

Solution 1

Use Dts.Events.FireInformation instead.

Solution 2

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