This topic has not yet been rated - Rate this topic

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)

Syntax

C++

JScript

Copy

public string[] GetDtsServerRoles(
	string sFolderPath,
	string sServerName
)

Parameters

sFolderPath: Type: System.String
The folder whose roles you are interested in.

sServerName: 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.

Examples

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.

Copy

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

Reference

Application Class

Microsoft.SqlServer.Dts.Runtime Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)