debugging SSIS packages - debug.writeline

2020-07-16 08:28发布

问题:

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?

回答1:

Use Dts.Events.FireInformation instead.



回答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