CODEWITHSUNDEEP
sql-serverssisssis-2012
Hardik
Hardik

Reputation: 145

SSIS package run as SQL Server Authentication in SQL Server

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

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?

Upvotes: 0

Views: 367

Answers (0)

Related Questions