Package.VersionComments Proprietà

Definizione

Spazio dei nomi:

Microsoft.SqlServer.Dts.Runtime

Assembly:

Microsoft.SqlServer.ManagedDTS.dll

Ottiene i commenti sulla versione associati al pacchetto.

public:
 property System::String ^ VersionComments { System::String ^ get(); void set(System::String ^ value); };

[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), "VersionCommentsDesc")]
public string VersionComments { get; set; }

[<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), "VersionCommentsDesc")>]
member this.VersionComments : string with get, set

Public Property VersionComments As String

Valore della proprietà

String

Commenti sulla versione per il pacchetto.

Attributi

LocalizablePropertyCategoryAttribute LocalizablePropertyDescriptionAttribute

Esempio

Nell'esempio seguente vengono recuperate le informazioni sulla versione da un pacchetto installato con gli esempi 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  

Esempio di output

Build number for package 143

any comments?

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

Version numbers 1.0