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)