Application.GetServerVersionEx(String, Int32, DTSProductLevel, String, String) Application.GetServerVersionEx(String, Int32, DTSProductLevel, String, String) Application.GetServerVersionEx(String, Int32, DTSProductLevel, String, String) Method


Returns the edition, product level, and other values that indicate the version of SSIS installed.

 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);
Public Sub GetServerVersionEx (server As String, ByRef editionID As Integer, ByRef ssisEditionID As DTSProductLevel, ByRef productVersion As String, ByRef productLevel As String)


String String String

The name of the server to get the product version information from.


An out parameter containing an integer that indicates the edition of the product. The mapping of the editionID to the edition name is shown in the Remarks section.

DTSProductLevel DTSProductLevel DTSProductLevel

An out parameter containing a value from the DTSProductLevel enumeration.


An out parameter containing the build number as seen in Help / About, formatted as


An out parameter providing the service pack level of the SSIS server.


The following example shows the values returned for each out parameter

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)   
        End Sub   
    End Class   
End Namespace  

Sample Output:

serverName: <your server name>

Edition: 4

prodLevel: Enterprise


The following table lists the values for the ssisEditionID parameter.

EditionID Edition Name
0xA485ED98 Standard
0x6B9471A8 Enterprise
0x81C1F4D2 Developer
0x2467BCA1 Enterprise Evaluation

Applies to