CODEWITHSUNDEEP
loggingssisscript-task
FLICKER
FLICKER

Reputation: 6683

SSIS Script Task : How to log to output using Dts.Log

I searched a lot for this but no luck.

I have a script task and inside that I've written some C# code. I have a look and I want to print output like what we see in Output Window

I'm using Dts.Log() using below code:

Dts.Log("List of files are loaded: ", 0, new byte[0]);

But I don't see anything in output window.

I already have enabled logging as you see:

SSIS Log Configuration

I know if I use 

Dts.Events.FireInformation

It does the job, but I like to know how I can use Dts.Log() for this purpose.

Upvotes: 5

Views: 13207

Answers (1)

Andrew
Andrew

Reputation: 7880

A very old question, but it may be worth answering anyway.

When you use Dts.Log, it doesn't go to the output screen but to the log window. So you should open the SSIS menu and select the "Log Events" entry.

If your SSIS menu is missing that option, try clicking on the control flow window or the Script Task node.

More info in How to check the SSIS package job results after it has completed its execution?.

Upvotes: 4

Related Questions