Package.CreatorName プロパティ
パッケージを作成した個人の名前を取得します。値の設定も可能です。
名前空間: Microsoft.SqlServer.Dts.Runtime
アセンブリ: Microsoft.SqlServer.ManagedDTS (Microsoft.SqlServer.ManagedDTS.dll)
構文
'宣言
Public Property CreatorName As String
Get
Set
'使用
Dim instance As Package
Dim value As String
value = instance.CreatorName
instance.CreatorName = value
public string CreatorName { get; set; }
public:
property String^ CreatorName {
String^ get ();
void set (String^ value);
}
member CreatorName : string with get, set
function get CreatorName () : String
function set CreatorName (value : String)
プロパティ値
型: System.String
パッケージの作成者の名前です。
使用例
次の例では、Samples フォルダーからパッケージを読み込み、CreationDate、CreatorComputerName、CreatorName など、パッケージに関する情報を取得します。
static void Main(string[] args)
{
// The variable pkg points to the location
// of the ExecuteProcess package sample
// that is installed with the samples.
string pkg = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx";
Application app = new Application();
Package p = app.LoadPackage(pkg, null);
//Retrieve creation information about the package.
DateTime createDate = p.CreationDate;
String computerCreated = p.CreatorComputerName;
String creatorName = p.CreatorName;
Console.WriteLine("Package creation date = " + createDate);
Console.WriteLine("Creation Computer = " + computerCreated);
Console.WriteLine("Creator Name = " + creatorName);
}
Shared Sub Main(ByVal args() As String)
' The variable pkg points to the location
' of the ExecuteProcess package sample
' that is installed with the samples.
Dim pkg As String = "C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx"
Dim app As Application = New Application()
Dim p As Package = app.LoadPackage(pkg,Nothing)
'Retrieve creation information about the package.
Dim createDate As DateTime = p.CreationDate
Dim computerCreated As String = p.CreatorComputerName
Dim creatorName As String = p.CreatorName
Console.WriteLine("Package creation date = " + createDate)
Console.WriteLine("Creation Computer = " + computerCreated)
Console.WriteLine("Creator Name = " + creatorName)
End Sub
サンプルの出力:
Package creation date = 5/5/2003 5:46:00 PM
Creation Computer =
Creator Name =