SSIS package run as SQL Server Authentication in SQL Server

119 Views Asked by At

Can any one please help me to RUN my SSIS package is SQL Server Authentication Becuase it is excuted.

it is My Stored Procedure Calling method for the SSIS package using SQL Server Authentication

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
  • The [catalog].[create_execution] and [catalog].[set_execution_parameter_value] is Run succesfully using EXECUTE AS LOGIN it but [catalog].[start_execution] @execution_id throw error.

ERROR :

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: 

Can anyone help me into it am not able to run Job as we need to set dynamic parameter value so can anyone help me into it?

0

There are 0 best solutions below