Application.GetServerVersionEx 方法

  • 參考

定義

命名空間:
Microsoft.SqlServer.Dts.Runtime
組件:
Microsoft.SqlServer.ManagedDTS.dll

傳回版本、產品層級和其他表示 SSIS 已安裝之版本的值。

public:
 void GetServerVersionEx(System::String ^ server, [Runtime::InteropServices::Out] int % editionID, [Runtime::InteropServices::Out] Microsoft::SqlServer::Dts::Runtime::DTSProductLevel % ssisEditionID, [Runtime::InteropServices::Out] System::String ^ % productVersion, [Runtime::InteropServices::Out] System::String ^ % productLevel);
public void GetServerVersionEx (string server, out int editionID, out Microsoft.SqlServer.Dts.Runtime.DTSProductLevel ssisEditionID, out string productVersion, out string productLevel);
member this.GetServerVersionEx : string * int * DTSProductLevel * string * string -> unit
Public Sub GetServerVersionEx (server As String, ByRef editionID As Integer, ByRef ssisEditionID As DTSProductLevel, ByRef productVersion As String, ByRef productLevel As String)

參數

server
String

要從中取得產品版本資訊的伺服器名稱。

editionID
Int32

Out 參數，其中包含表示產品版本的整數。 與版本名稱的 editionID 對應會顯示在＜備註＞一節。

ssisEditionID
DTSProductLevel

Out 參數，其中包含列舉中的值 DTSProductLevel 。

productVersion
String

輸出參數，其中包含在 [說明]/[關於] 中所見的組建編號，格式為 [主要]. [組建]。

productLevel
String

輸出參數，提供 SSIS 伺服器的 service pack 層級。

範例

下列範例會顯示針對每個輸出參數傳回的值。

using System;  
using System.Collections.Generic;  
using System.Text;  
using Microsoft.SqlServer.Dts.Runtime;  

namespace Microsoft.SqlServer.SSIS.Samples  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            String serverName = "yourServerName";  
            int ed;  
            DTSProductLevel prodLevel = new DTSProductLevel();  
            String prodVersion;  
            string prodReleaseLevel;     
            Application app = new Application();  
            app.GetServerVersionEx(serverName, out ed, out prodLevel, out prodVersion, out prodReleaseLevel);  

            Console.WriteLine("servernName:     {0}", serverName);  
            Console.WriteLine("Edition:         {0}", ed);  
            Console.WriteLine("prodLevel:       {0}", prodLevel);  
            //Console.WriteLine("prodVersion:     {0}", prodVersion);  
            //Console.WriteLine("prodReleaseLevel {0}", prodReleaseLevel);  
        }  
    }  
}  

Imports System   
Imports System.Collections.Generic   
Imports System.Text   
Imports Microsoft.SqlServer.Dts.Runtime   
Namespace Microsoft.SqlServer.SSIS.Samples   

    Class Program   

        Shared Sub Main(ByVal args As String())   
            Dim servernName As String = "yourServerName"   
            Dim ed As Integer   
            Dim prodLevel As DTSProductLevel = New DTSProductLevel   
            Dim prodVersion As String   
            Dim prodReleaseLevel As String   
            Dim app As Application = New Application   
            app.GetServerVersionEx(servernName, ed, prodLevel, prodVersion, prodReleaseLevel)   

            Console.WriteLine("servernName: {0}", servernName)   
            Console.WriteLine("Edition: {0}", ed)   
            Console.WriteLine("prodLevel: {0}", prodLevel)   
            'Console.WriteLine("prodVersion: {0}", prodVersion)   
            'Console.WriteLine("prodReleaseLevel {0}", prodReleaseLevel)   
            Console.WriteLine   
        End Sub   
    End Class   
End Namespace

範例輸出：

serverName: <your server name>

Edition: 4

prodLevel: Enterprise

備註

下表列出參數的值 ssisEditionID 。

EditionID 版本名稱
0xA485ED98 標準
0x6B9471A8 企業
0x81C1F4D2 開發人員
0x2467BCA1 Enterprise Evaluation

適用於