Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

debugging SSIS packages - debug.writeline

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?

like image 262
cometbill Avatar asked Jul 08 '10 11:07

cometbill


2 Answers

Use Dts.Events.FireInformation instead.

like image 93
Todd McDermid Avatar answered Sep 29 '22 20:09

Todd McDermid


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

like image 30
Mitch Wheat Avatar answered Sep 29 '22 21:09

Mitch Wheat