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()
public string[] GetDtsServerRoles (
string sFolderPath,
string sServerName
)
public:
array<String^>^ GetDtsServerRoles (
String^ sFolderPath,
String^ sServerName
)
public String[] GetDtsServerRoles (
String sFolderPath,
String sServerName
)
public function GetDtsServerRoles (
sFolderPath : String,
sServerName : String
) : String[]
Parameters
- sFolderPath
The folder whose roles you are interested in.
- sServerName
The name of the instance that is running the Integration Services service.
Return Value
An array of Strings, each string containing a role name.
Example
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)
Thread Safety
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
See Also
Reference
Application Class
Application Members
Microsoft.SqlServer.Dts.Runtime Namespace