This topic has not yet been rated - Rate this topic

Application.GetPackageRoles Method

Returns the database roles that have read access and write access to the package. Database roles apply only to packages stored in the SQL Server msdb database.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

Syntax

C++

JScript

Copy

public void GetPackageRoles(
	string serverName,
	string packagePath,
	out string readerRole,
	out string writerRole
)

Parameters

serverName: Type: System.String
Specify the name and instance of the server that contains the package.

packagePath: Type: System.String
Specify the name of the package.

readerRole: Type: System.String%
Returns the roles with read access.

writerRole: Type: System.String%
Returns the roles with write access.

Examples

The following code example shows how to retrieve the package roles, assuming the variables have been set to reflect your specific server name, package path, and roles.

Copy

string readerRole = null;
string writerRole = null;
app.GetPackageRoles(myServerName, packagePath, out readerRole, out writerRole);

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)