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?

score 6 · Accepted Answer · answered Jul 09 '10 at 01:02

6

Use Dts.Events.FireInformation instead.

answered Jul 09 '10 at 01:02

Todd McDermid

1,650
11
12

good call Todd. You can also use Dts.Log() but viewing this is slightly more cumbersome – Jason Horner Jul 09 '10 at 03:45

score 4 · Answer 2 · edited May 23 '17 at 12:30

4

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

edited May 23 '17 at 12:30

Community

1
1

answered Jul 08 '10 at 11:30

Mitch Wheat

295,962
43
465
541

Thanks for those. Any articles on using debug.writeline ? – cometbill Jul 08 '10 at 14:06

debugging SSIS packages - debug.writeline

2 Answers2

Linked