Debugging SSIS packages - debug.writeline

Question

The debugging experience in SSIS is not what I expect.

I have a script task in which I added Imports System.Diagnostics to the class header, and in the code I have various messages like debug.writeline ("Attemtpting to move file").

But they do not appear in the output window.

Did I miss something?

Answer 1

Use Dts.Events.FireInformation instead .

Answer 2

How to debug a package by setting breakpoints in a task or container

Control flow debugging

SQL Server 2005 Integration Services SSIS Breakpoints

Viewing Variables in SSIS During Debugging - Stack Overflow

To write Debug.WriteLine output, download and run standalone DebugView