LoggingOptions Class


Contains members that regulate what information is included or excluded from logging. This class cannot be inherited.

public ref class LoggingOptions sealed : Microsoft::SqlServer::Dts::Runtime::DtsObject, Microsoft::SqlServer::Dts::Runtime::IDTSPersist
public sealed class LoggingOptions : Microsoft.SqlServer.Dts.Runtime.DtsObject, Microsoft.SqlServer.Dts.Runtime.IDTSPersist
type LoggingOptions = class
    inherit DtsObject
    interface IDTSPersist
Public NotInheritable Class LoggingOptions
Inherits DtsObject
Implements IDTSPersist


Logging options add a filtering capability to restrict logging output to only those items you are interested in, which reduces impact on the system in terms of performance. Logging is meant for diagnostic and analytic usage, rather than progress tracking.



Gets or sets an array that contains the names of the events that are the subject of the filtering options.


Gets or sets a value that describes the kind of event filter that is set, whether included or excluded.


A collection of log providers selected on the container. A log provider can only be selected for a container when the container's LoggingMode is set to Enabled.



Determines whether two object instances are equal.

(Inherited from DtsObject)
GetColumnFilter(String, DTSEventColumnFilter)

Returns column filter for the specified event.


Returns a string array that contains a list of events that have a column filter set.


Returns the hash code for this instance.

(Inherited from DtsObject)
LoadFromXML(XmlNode, IDTSEvents)

This method is not callable by your application code. To load a package saved as .xml, use the LoadPackage(String, IDTSEvents) method.

SaveToXML(XmlDocument, XmlNode, IDTSEvents)

This method is not callable by your application code. To save a package as .xml, use the SaveToXml(String, Package, IDTSEvents) method.

SetColumnFilter(String, DTSEventColumnFilter)

Sets column filter for the specified event.

Applies to