Share via


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

'Declaration
Public Function GetDtsServerRoles ( _
    sFolderPath As String, _
    sServerName As String _
) As String()
'Usage
Dim instance As Application 
Dim sFolderPath As String 
Dim sServerName As String 
Dim returnValue As String()

returnValue = instance.GetDtsServerRoles(sFolderPath, _
    sServerName)
public string[] GetDtsServerRoles(
    string sFolderPath,
    string sServerName
)
public:
array<String^>^ GetDtsServerRoles(
    String^ sFolderPath, 
    String^ sServerName
)
member GetDtsServerRoles : 
        sFolderPath:string * 
        sServerName:string -> string[] 
public function GetDtsServerRoles(
    sFolderPath : String, 
    sServerName : String
) : String[]

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

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

See Also

Reference

Application Class

Microsoft.SqlServer.Dts.Runtime Namespace