Application.GetDtsServerRoles Method

Returns an array of Strings that lists the roles available for a folder.

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

public string[] GetDtsServerRoles(
	string sFolderPath,
	string sServerName


Type: System.String
The folder whose roles you are interested in.
Type: System.String
The name of the instance that is running the Integration Services service.

Return Value

Type: System.String[]
An array of Strings, each string containing a role name.

The following code example shows how to retrieve the server roles, assuming the variables have been set to reflect your specific server name and folder path.

string[] availableRoles = app.GetDtsServerRoles(folderPath, myServerName); 

Community Additions