February 19, 2018 at 9:42 am
Hi Team,
I am trying to run ssis using T-SQL , I googled and got the below code. I am wondering is it possible to run this script with different user instead of windows authentication by default?
Is there any key word that I can use in the below script for user name so that it overwrites the windows authentication?
Declare @execution_id bigintEXEC [SSISDB].[catalog].[create_execution] @package_name=N'Package.dtsx', @execution_id=@execution_id OUTPUT, @folder_name=N'Deployed Projects', @project_name=N'Integration Services Project1', @use32bitruntime=False, @reference_id=NullSelect @execution_idDECLARE @var0 smallint = 1EXEC [SSISDB].[catalog].[set_execution_parameter_value] @execution_id, @object_type=50, @parameter_name=N'LOGGING_LEVEL', @parameter_value=@var0EXEC [SSISDB].[catalog].[start_execution] @execution_idGO
Thanks,
Charmer
February 19, 2018 at 10:14 am
SSIS tasks have to be run using Windows Authentication; they cannot be run by SQL Logins. EXECUTE AS does not even get around this; as that is impersonation it's not true authentication. There is no get around for this, as it's an intentional Security feature.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 20, 2018 at 2:24 am
Thank you, Thom. My guess was correct. 🙂
Thanks,
Charmer
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply