Export (0) Print
Expand All

Application.GetServerVersionEx Method

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

Namespace:  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

public void GetServerVersionEx(
	string server,
	out int editionID,
	out DTSProductLevel ssisEditionID,
	out string productVersion,
	out string productLevel
)

Parameters

server
Type: System.String
The name of the server to get the product version information from.
editionID
Type: System.Int32%
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
Type: Microsoft.SqlServer.Dts.Runtime.DTSProductLevel%
An out parameter containing a value from the DTSProductLevel enumeration.
productVersion
Type: System.String%
An out parameter containing the build number as seen in Help / About, formatted as major.minor.build.
productLevel
Type: System.String%
An out parameter providing the service pack level of the SSIS server.

The following table lists the values for the ssisEditionID parameter.

EditionID

Edition Name

0xA485ED98

Standard

0x6B9471A8

Enterprise

0x81C1F4D2

Developer

0x2467BCA1

Enterprise Evaluation

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);
        }
    }
}

Sample Output:

serverName: <your server name>

Edition: 4

prodLevel: Enterprise

Community Additions

ADD
Show:
© 2014 Microsoft