LogProvider.InnerObject Property
SQL Server 2008 R2
Returns the specific log provider that is being hosted by the LogProvider object.
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
The following code example loads a package for which logging has been enabled. After loading the package, the LogProviders collection is created, and each log provider in the collection is enumerated over, printing the values for each property, including the InnerObject.
using System; using System.Collections.Generic; using System.Text; using Microsoft.SqlServer.Dts.Runtime; using Microsoft.SqlServer.Dts.Tasks.DMQueryTask; namespace LogProvider_Properties_Test { class Program { static void Main(string[] args) { // The package is one of the SSIS samples, // modified to log information to the "SSIS // log provider for Text files". string mySample = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx"; // Create the Application, and load the sample. Application app = new Application(); Package pkg = app.LoadPackage(mySample, null); // Get the LogProviders collection from the package. LogProviders logProvs = pkg.LogProviders; foreach (LogProvider logProv in logProvs) { Console.WriteLine("ConfigString: {0}", logProv.ConfigString); Console.WriteLine("CreationName {0}", logProv.CreationName); Console.WriteLine("DelayValidation {0}", logProv.DelayValidation); Console.WriteLine("Description {0}", logProv.Description); Console.WriteLine("HostType {0}", logProv.HostType); Console.WriteLine("ID {0}", logProv.ID); Console.WriteLine("InnerObject {0}", logProv.InnerObject); Console.WriteLine("Name {0}", logProv.Name); } } } }
Sample Output:
ConfigString:
CreationName DTS.LogProviderTextFile.2
DelayValidation False
Description Writes log entries for events to a CSV file
HostType LogProvider
ID {1E107E39-DB79-4F02-B8A7-61D88F2DEF63}
InnerObject System.__ComObject
Name SSIS log provider for Text files