Package.VersionGUID プロパティ
パッケージが最初に作成されるときに生成されるバージョン GUID を取得します。 このフィールドは読み取り専用です。
名前空間: Microsoft.SqlServer.Dts.Runtime
アセンブリ: Microsoft.SqlServer.ManagedDTS (Microsoft.SqlServer.ManagedDTS.dll)
構文
'宣言
Public ReadOnly Property VersionGUID As String
Get
'使用
Dim instance As Package
Dim value As String
value = instance.VersionGUID
public string VersionGUID { get; }
public:
property String^ VersionGUID {
String^ get ();
}
member VersionGUID : string
function get VersionGUID () : String
プロパティ値
型: System.String
パッケージのバージョン GUID です。
使用例
次の例では、SSIS サンプルと共にインストールされたパッケージから、バージョン情報を取得します。
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
namespace Package_API
{
class Program
{
static void Main(string[] args)
{
Application app = new Application();
Package pkg = new Package();
pkg = app.LoadPackage(@"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx", null);
// Review several properties on the sample package using different techniques.
int pkgBuild = pkg.VersionBuild;
int pkgVerMajor = pkg.VersionMajor;
int pkgVerMinor = pkg.VersionMinor;
String entireVersion = pkgVerMajor.ToString() + "." + pkgVerMinor.ToString();
Console.WriteLine("Build number for package {0}", pkgBuild);
Console.WriteLine("any comments? {0}", pkg.VersionComments);
Console.WriteLine("What is the GUID? {0}", pkg.VersionGUID);
Console.WriteLine("Version numbers {0}", entireVersion);
}
}
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Namespace Package_API
Class Program
Shared Sub Main(ByVal args() As String)
Dim app As Application = New Application()
Dim pkg As Package = New Package()
pkg = app.LoadPackage("C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx", Nothing)
' Review several properties on the sample package using different techniques.
Dim pkgBuild As Integer = pkg.VersionBuild
Dim pkgVerMajor As Integer = pkg.VersionMajor
Dim pkgVerMinor As Integer = pkg.VersionMinor
Dim entireVersion As String = pkgVerMajor.ToString() + "." + pkgVerMinor.ToString()
Console.WriteLine("Build number for package {0}", pkgBuild)
Console.WriteLine("any comments? {0}", pkg.VersionComments)
Console.WriteLine("What is the GUID? {0}", pkg.VersionGUID)
Console.WriteLine("Version numbers {0}", entireVersion)
End Sub
End Class
End Namespace
サンプルの出力:
Build number for package 143
any comments?
What is the GUID? {0FF64FA0-2FB7-49C1-BB20-6439EDD1EE44}
Version numbers 1.0