共用方式為


IDTSApplication100.SetPackageRoles 方法

此 API 支援 SQL Server 2012 基礎結構,但無法直接從您的程式碼使用。

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.

命名空間:  Microsoft.SqlServer.Dts.Runtime.Wrapper
組件:  Microsoft.SqlServer.DTSRuntimeWrap (在 Microsoft.SqlServer.DTSRuntimeWrap.dll 中)

語法

'宣告
Sub SetPackageRoles ( _
    bstrServerName As String, _
    bstrPackagePath As String, _
    bstrReaderRole As String, _
    bstrWriterRole As String _
)
'用途
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
)

參數

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

請參閱

參考

IDTSApplication100 介面

Microsoft.SqlServer.Dts.Runtime.Wrapper 命名空間