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

Definition

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

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

Parameters

server
String String String

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

editionID

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.

ssisEditionID
DTSProductLevel DTSProductLevel DTSProductLevel

An out parameter containing a value from the DTSProductLevel enumeration.

productVersion

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

productLevel

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

Examples

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

Sample Output:

serverName: <your server name>

Edition: 4

prodLevel: Enterprise

Remarks

The following table lists the values for the ssisEditionID parameter.

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

Applies to