提问人:Hardik 提问时间:11/16/2023 最后编辑:Hardik 更新时间:11/16/2023 访问量:37
SSIS 包在 SQL Server 中作为 SQL Server 身份验证运行
SSIS package run as SQL Server Authentication in SQL Server
问:
任何人都可以帮助我运行我的SSIS包是SQL Server身份验证,因为它是执行的。
它是使用 SQL Server 身份验证的 SSIS 包的 My Stored Procedure 调用方法
DECLARE @execution_id BIGINT;
EXECUTE AS LOGIN = 'windowsuser';
EXEC [SSISDB].[catalog].[create_execution]
@package_name = @package_name
, @execution_id = @execution_id OUTPUT
, @folder_name = @folder_name
, @project_name = @project_name
, @use32bitruntime = False
, @reference_id = NULL
, @runinscaleout = False;
EXEC [SSISDB].[catalog].[set_execution_parameter_value]
@execution_id
, @object_type = 30
, @parameter_name = N'SbInvoiceID'
, @parameter_value = @SBInvoiceId;
EXEC [SSISDB].[catalog].[start_execution] @execution_id;
REVERT
- [目录]。create_execution] 和 [目录]。set_execution_parameter_value] 使用 EXECUTE AS LOGIN 成功运行,但 [catalog]。start_execution] @execution_id抛出错误。
错误:
Msg 27123, Level 16, State 1, Line 3
The operation cannot be started by an account that uses SQL Server Authentication. Start the operation with an account that uses Integrated Authentication.
Msg 6522, Level 16, State 1, Procedure internal.start_execution_internal, Line 0 [Batch Start Line 2]
A .NET Framework error occurred during execution of user-defined routine or aggregate "start_execution_internal":
System.Data.SqlClient.SqlException: The operation cannot be started by an account that uses SQL Server Authentication. Start the operation with an account that uses Integrated Authentication.
System.Data.SqlClient.SqlException:
谁能帮我进入它,但无法运行作业,因为我们需要设置动态参数值,所以任何人都可以帮我进入它吗?
答: 暂无答案
评论
EXECUTE AS
LOGIN
INSERT