InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 01:37:23 GMT20http://www.sqlservercentral.com/Forums/Topic606873-148-1.aspx[quote][b]SSIS Guy (5/2/2011)[/b][hr]See this Article about implementing [url=http://pragmaticworks.com/Products/Business-Intelligence/BIxPress/ssis-logging-auditing-monitoring.aspx]custom ssis logging[/url] various ways. [url=http://pragmaticworks.com/Products/Business-Intelligence/BIxPress/ssis-logging-auditing-monitoring.aspx]http://pragmaticworks.com/Products/Business-Intelligence/BIxPress/ssis-logging-auditing-monitoring.aspx[/url][/quote]Thanks for linking to an ad for a commercial product! Big help!Mon, 01 Oct 2012 13:19:54 GMTphil.vaccahttp://www.sqlservercentral.com/Forums/Topic606873-148-1.aspxSee this Article about implementing [url=http://pragmaticworks.com/Products/Business-Intelligence/BIxPress/ssis-logging-auditing-monitoring.aspx]custom ssis logging[/url] various ways. [url=http://pragmaticworks.com/Products/Business-Intelligence/BIxPress/ssis-logging-auditing-monitoring.aspx]http://pragmaticworks.com/Products/Business-Intelligence/BIxPress/ssis-logging-auditing-monitoring.aspx[/url]Mon, 02 May 2011 11:13:06 GMTSSIS Guyhttp://www.sqlservercentral.com/Forums/Topic606873-148-1.aspxHi,I've got exactly the same problem, except I can't get [b]Dts.Log[/b] to work at all (even when I have ScriptTaskLogEntry option switched on in Logging for the script task).[b]Re. the FireInformation method...[/b]Basically, I've tried setting logging options at the script level (to override those at the package level), and also just setting them at the script level. I've tried various combinations of events to capture (at both of the above levels) - and found that the FireInformation method logs the event regardless of whether the Information or ScriptTaskLogEntry options are switched on. I've tried not logging the Source Name column. I've tried various values in the parameters to the FireInformation method, including setting the subComponent parameter to the name of the script, the name of the package, an empty string, something else, etc.In all cases, I get 2 lines logged for each call to this method - one with the script name being recorded as the Source Name, and the other with the package name being recorded as the Source Name.Sorry I have no solution. It certainly looks like a bug!Fri, 14 May 2010 04:24:11 GMTPaul Knoxhttp://www.sqlservercentral.com/Forums/Topic606873-148-1.aspxIs this so "out there" that no one really works with SSIS this way?Tue, 25 Nov 2008 07:23:56 GMTDEK46656http://www.sqlservercentral.com/Forums/Topic606873-148-1.aspxI am trying to write a generic script task that will log the changes to any variable (properly enabled, etc) from within an error handler for OnVariableValueChanged. I am trying to capture when a variable changes and record the results to the SSIS logging process (as opposed to some specialized logging that I have to create separately).[code]Public Class ScriptMain Public Sub Main() 'System::VariableName,System::VariableValue,System::VariableDescription Dim emptyBytes(0) As Byte Dim vName As Variable = Dts.Variables("System::VariableName") Dim vDesc As Variable = Dts.Variables("System::VariableDescription") Dim vValue As Variable = Dts.Variables("System::VariableValue") If (vName.Value().ToString.Contains("New") = True) Then Dts.Events.FireWarning(CType(vValue.Value(), Integer), vName.Value().ToString, vDesc.Value().ToString & ": " & vValue.Value().ToString, "", 0) ElseIf (vName.Value().ToString.Contains("Missing") = True) Then Dts.Events.FireError(CType(vValue.Value(), Integer), vName.Value().ToString, vDesc.Value().ToString & ": " & vValue.Value().ToString, "", 0) Else Dts.Events.FireInformation(CType(vValue.Value(), Integer), vName.Value().ToString, vDesc.Value().ToString & ": " & vValue.Value().ToString, "", 0, False) End If Dts.TaskResult = Dts.Results.Success End SubEnd Class[/code]The problem is that no matter what I try in the “logging” settings of the package, it will either not output anything, or will “double” the output, once with the Source “OnVariableValueChanged” and once with the name of the script component that runs inside of the event handler (screen).You will notice that I am using one of the “Fire” Events since the “Dts.Log” method only works from a script task (and logging parameter ScriptTaskLogEntry on), not from an error handler or data flow task.Has anyone ever done this, are they familiar with the problem, or is this a “bug” that no one has run into yet?Fri, 21 Nov 2008 15:39:06 GMTDEK46656