SelectedLogProviders.Add Method (LogProvider)


Adds the specified log provider object, LogProvider, to the end of the collection.

Namespace:   Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

public void Add(
	LogProvider logProvider


Type: Microsoft.SqlServer.Dts.Runtime.LogProvider

The log provider to add to the collection.

This method associates a log provider to a specific container. The package is a type of container, so the code example specifies that all logs for the package go to DTS.LogProviderXMLFile.1.

You can set a SelectedLogProvider for any task by using the tasks' LoggingOptions collection inherited from DtsContainer, just like the sample shows for the package.

The following code example creates a log provider, then selects is as the log provider for the package.

LogProvider provider = package.LogProviders.Add("DTS.LogProviderXMLFile.1");
provider.ConfigString = "c:\\DTSPackageLog.xml";

[Visual Basic]

Dim provider As LogProvider =   package.LogProviders.Add("DTS.LogProviderXMLFile.1") 
provider.ConfigString = "c:\\DTSPackageLog.xml"
Return to top