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.
Gets or sets the name of the DtsContainer.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
Syntax
'Declaration
Public Property Name As String
Get
Set
'Usage
Dim instance As DtsContainer
Dim value As String
value = instance.Name
instance.Name = value
public string Name { get; set; }
public:
virtual property String^ Name {
String^ get () sealed;
void set (String^ value) sealed;
}
abstract Name : string with get, set
override Name : string with get, set
final function get Name () : String
final function set Name (value : String)
Property Value
Type: System.String
A String that indicates the name of the DtsContainer.
Implements
Examples
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);
}
}
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Namespace Microsoft.SqlServer.SSIS.Samples
Class Program
Shared Sub Main(ByVal args() As String)
Dim app As Application = New Application()
Dim pkg As Package = 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)
End Sub
End Class
End Namespace
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