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 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