• Article

SelectedLogProviders.Add Method

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)

Syntax

'Declaration
Public Sub Add ( _
    logProvider As LogProvider _
)
'Usage
Dim instance As SelectedLogProviders
Dim logProvider As LogProvider

instance.Add(logProvider)

public void Add(
    LogProvider logProvider
)

public:
void Add(
    LogProvider^ logProvider
)

member Add : 
        logProvider:LogProvider -> unit 

public function Add(
    logProvider : LogProvider
)

Parameters

Remarks

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.2.

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.

Examples

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.2");
provider.ConfigString = "c:\\DTSPackageLog.xml";
package.LoggingOptions.SelectedLogProviders.Add(provider);

[Visual Basic]

Dim provider As LogProvider =   package.LogProviders.Add("DTS.LogProviderXMLFile.2") 
provider.ConfigString = "c:\\DTSPackageLog.xml"
package.LoggingOptions.SelectedLogProviders.Add(provider)