question

AjMahato avatar image
AjMahato asked

Executing an SSIS Task from a SQL Authentication Login

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.

ssissql-server-2016
1621420242590.png (14.6 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
harbingergroup avatar image
harbingergroup answered

Refer below url for your issue.

http://dba.stackexchange.com/questions/80507/issues-with-module-signing-and-ssis-catalog-internal-procedures 
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.