Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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)

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

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.

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.

Dim availableRoles() As String =  app.GetDtsServerRoles(folderPath,myServerName)

Community Additions

ADD
Show:
© 2015 Microsoft