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, 
	[OutAttribute] int% editionID, 
	[OutAttribute] DTSProductLevel% ssisEditionID, 
	[OutAttribute] String^% productVersion, 
	[OutAttribute] 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.

Parameters

server

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

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.

New: 5 December 2005

EditionID

Edition Name

0xA485ED98

Standard Edition

0x6B9471A8

Enterprise Edition

0x81C1F4D2

Developer Edition

0x2467BCA1

Enterprise Evaluation Edition


The following example shows the values returned for each out parameter

No code example is currently available or this language may not be supported.

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

Community Additions

ADD
Show:
© 2014 Microsoft