DtsContainer.IsolationLevel Property
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)
/** @property */ public IsolationLevel get_IsolationLevel () /** @property */ public void set_IsolationLevel (IsolationLevel value)
public function get IsolationLevel () : IsolationLevel public function set IsolationLevel (value : IsolationLevel)
Property Value
Returns an integer value that corresponds to the isolation level.The default value of this property is -1, or Unspecified. For more information about isolation levels and their use by SQL Server, see Isolation Levels in the Database Engine. For more information about the available values, see the IsolationLevel enumerations used in the System.Data namespace in ADO and in OLE DB.
The following table lists the available values for the IsolationLevel property:
|
Value |
Isolation Level |
|
-1 |
Unspecified |
|
16 |
Chaos |
|
256 |
ReadUncommitted |
|
4096 |
ReadCommitted |
|
65536 |
RepeatableRead |
|
1048576 |
Serializable |
The following code example creates a Package, which is a class that inherits from DtsContainer. The Package shows the use of several inherited properties.
using System; using System.Collections.Generic; using System.Text; using Microsoft.SqlServer.Dts.Runtime; namespace Microsoft.SqlServer.SSIS.Samples { class Program { static void Main(string[] args) { Application app = new Application(); Package pkg = new Package(); // Package name must be assigned. pkg.Name = "My DtsContainer inheritance test package"; // Display the values that manually assigned. Console.WriteLine("Package Name: {0}", pkg.Name); // Packages are assigned the following default values when created. Console.WriteLine("Package ID: {0}", pkg.ID); Console.WriteLine("FailPackageOnFailure: {0}", pkg.FailPackageOnFailure); Console.WriteLine("FailParentOnFailure: {0}", pkg.FailParentOnFailure); Console.WriteLine("Locale ID: {0}", pkg.LocaleID); Console.WriteLine("Is DefaultLocaleID? {0}", pkg.IsDefaultLocaleID); Console.WriteLine("Isolation Level: {0}", pkg.IsolationLevel); Console.WriteLine("LoggingMode: {0}", pkg.LoggingMode); Console.WriteLine("MaximumErrorCount: {0}", pkg.MaximumErrorCount); Console.WriteLine("TransactionOption: {0}", pkg.TransactionOption); } } }
Sample Output:
Package Name: My DtsContainer inheritance test package
Package ID: {2C2FAA96-35BA-4C5E-A39A-C5D7D30A0D79}
FailPackageOnFailure: False
FailParentOnFailure: False
Locale ID: 1033
Is DefaultLocaleID? False
Isolation Level: Serializable
LoggingMode: UseParentSetting
MaximumErrorCount: 1
TransactionOption: Supported

