Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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
- logProvider
Type: Microsoft.SqlServer.Dts.Runtime.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.
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.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)