CODEWITHSUNDEEP
ssis
PseudoToad
PseudoToad

Reputation: 1574

SSIS Logging Using DTS.Events

I am running SSIS packages on SQL Server 2016 and am trying to log events using Dts.Events.FireInformation and Dts.Events.FireWarning. While these do show in the local IDE progress section, they are not appearing in the SSISDB Logs (e.g. R-Click on a package / Select Reports / All Execution). I also tried Dts.Log() but that didn't write either. I've used logging in the past (circa 2008R2) to the old ssis logging table. I know I can use that but would rather keep these all in oneplace.

Logging level is "Basic" which should pump out both OnInformation and OnWarning.

I did look at this post on StackOverFlow which looks like it had a viable answer; however, the link to that answer is dead.

Is this just not possible to do or am I doing something wrong?

Upvotes: 1

Views: 1047

Answers (1)

billinkc
billinkc

Reputation: 61221

When the packages run in Visual Studio, the Information and Warning events are logged to both the Package Results tab as well as the Output window.

That data only gets recorded into the SSISDB if the server is the one running the packages.

Upvotes: 1

Related Questions