This documentation is archived and is not being maintained.

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
public void GetServerVersionEx (
	String server, 
	/** @attribute OutAttribute() */ /** @ref */ int editionID, 
	/** @attribute OutAttribute() */ /** @ref */ DTSProductLevel ssisEditionID, 
	/** @attribute OutAttribute() */ /** @ref */ String productVersion, 
	/** @attribute OutAttribute() */ /** @ref */ String productLevel
JScript does not support passing value-type arguments by reference.



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.


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.

New: 5 December 2005


Edition Name


Standard Edition


Enterprise Edition


Developer Edition


Enterprise Evaluation Edition

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>

Editon: 4

prodLevel: Enterprise

prodVersion: 9.00.1306.00

prodReleaseLevel: CTP16

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms