SelectedLogProviders.Add Method

Artikel
12/03/2008

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 _
)

public void Add (
    LogProvider logProvider
)

public:
void Add (
    LogProvider^ logProvider
)

public void Add (
    LogProvider logProvider
)

public function Add (
    logProvider : LogProvider
)

Parameters

logProvider
The log provider to add to the collection.

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

Example

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";
package.LoggingOptions.SelectedLogProviders.Add(provider);

[Visual Basic]

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

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms