Share via

IDTSApplication100.SetPackageRoles Method

  • Article

This API supports the SQL Server 2012 infrastructure and is not intended to be used directly from your code.

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

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

Syntax

'Declaration
Sub SetPackageRoles ( _
    bstrServerName As String, _
    bstrPackagePath As String, _
    bstrReaderRole As String, _
    bstrWriterRole As String _
)
'Usage
Dim instance As IDTSApplication100 
Dim bstrServerName As String 
Dim bstrPackagePath As String 
Dim bstrReaderRole As String 
Dim bstrWriterRole As String

instance.SetPackageRoles(bstrServerName, _
    bstrPackagePath, bstrReaderRole, _
    bstrWriterRole)

void SetPackageRoles(
    string bstrServerName,
    string bstrPackagePath,
    string bstrReaderRole,
    string bstrWriterRole
)

void SetPackageRoles(
    [InAttribute] String^ bstrServerName, 
    [InAttribute] String^ bstrPackagePath, 
    [InAttribute] String^ bstrReaderRole, 
    [InAttribute] String^ bstrWriterRole
)

abstract SetPackageRoles : 
        bstrServerName:string * 
        bstrPackagePath:string * 
        bstrReaderRole:string * 
        bstrWriterRole:string -> unit

function SetPackageRoles(
    bstrServerName : String, 
    bstrPackagePath : String, 
    bstrReaderRole : String, 
    bstrWriterRole : String
)

Parameters

  • bstrServerName
    Type: System.String
    Specify the name and instance of the server that contains the package.
  • bstrPackagePath
    Type: System.String
    Specify the name of the package.
  • bstrReaderRole
    Type: System.String
    Specify a role to have read access.
  • bstrWriterRole
    Type: System.String
    Specify a role to have write access.

See Also

Reference

IDTSApplication100 Interface

Microsoft.SqlServer.Dts.Runtime.Wrapper Namespace