Package.CreatorComputerName プロパティ
パッケージが作成されたコンピューターの名前を取得します。値の設定も可能です。
名前空間: Microsoft.SqlServer.Dts.Runtime
アセンブリ: Microsoft.SqlServer.ManagedDTS (Microsoft.SqlServer.ManagedDTS.dll)
構文
'宣言
Public Property CreatorComputerName As String
Get
Set
'使用
Dim instance As Package
Dim value As String
value = instance.CreatorComputerName
instance.CreatorComputerName = value
public string CreatorComputerName { get; set; }
public:
property String^ CreatorComputerName {
String^ get ();
void set (String^ value);
}
member CreatorComputerName : string with get, set
function get CreatorComputerName () : String
function set CreatorComputerName (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 =