Package.VersionGUID Propiedad

Definición

Espacio de nombres:

Microsoft.SqlServer.Dts.Runtime

Ensamblado:

Microsoft.SqlServer.ManagedDTS.dll

Devuelve el GUID de la versión generado al crear el paquete por primera vez. Este campo es de solo lectura.

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

[Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyCategory(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "PropertyCategoryVersion")]
[Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyDescription(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "VersionGUIDDesc")]
public string VersionGUID { get; }

[<Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyCategory(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "PropertyCategoryVersion")>]
[<Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyDescription(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "VersionGUIDDesc")>]
member this.VersionGUID : string

Public ReadOnly Property VersionGUID As String

Valor de propiedad

String

El GUID de la versión del paquete.

Atributos

LocalizablePropertyCategoryAttribute LocalizablePropertyDescriptionAttribute

Ejemplos

En el ejemplo siguiente se recupera información de versión de un paquete instalado con los ejemplos de 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  

Salida del ejemplo:

Build number for package 143

any comments?

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

Version numbers 1.0