Package.VersionGUID Property

Returns a unique GUID generated when the package is first created. This field is read-only.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly : Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Syntax

'Declaration
Public ReadOnly Property VersionGUID As String

public string VersionGUID { get; }

public:
property String^ VersionGUID {
    String^ get ();
}

/** @property */
public String get_VersionGUID ()

public function get VersionGUID () : String

Eigenschaftswert

A String that contains the version GUID for the package.

Beispiel

The following example retrieves version information from a package installed with the SSIS samples.

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\90\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\90\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

Sample Output:

Build number for package 143

any comments?

What is the GUID? {0FF64FA0-2FB7-49C1-BB20-6439EDD1EE44}

Version numbers 1.0

Threadsicherheit

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Plattformen

Entwicklungsplattformen

Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.

Zielplattforme

Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.

Siehe auch

Verweis

Package Class
Package Members
Microsoft.SqlServer.Dts.Runtime Namespace