I am trying to execute a SSIS package deployed in the server but I get the error
"The operation cannot be started by an account that uses SQL Server Authentication. Start the operation with an account that uses Windows Authentication."
Here is my code to execute the package.
declare @parameterValue nvarchar(200)
set @parameterValue='D:\DriverImpact\'
declare @output_execution_id bigint
declare @execution_id bigint
exec ssisdb.catalog.create_execution
@folder_name = 'DriverImpact'
,@project_name = 'Integration Services Project2'
,@package_name = 'Package1.dtsx'
,@execution_id = @execution_id output
EXEC [SSISDB].[catalog].[set_execution_parameter_value]
@object_type= 20
,@execution_id = @execution_id
, @parameter_name = N'MainFolder'
, @parameter_value = @parameterValue;
exec ssisdb.catalog.start_execution @execution_id
set @output_execution_id = @execution_id
select @output_execution_id as 'output'
I found a similar question in the forum but I could not replicate the solution provide in it. Any help is highly appreciated.
