sql - SSIS Package What credential SSIS is running? -
i have package access excel file .xls. file located on network path. the packaged called store pass use32bitruntime = true. store called c# code. if file local file => package run successfully. if file network path => package run failed. checking network path: can access network path , open file manually successful. so question credential ssis package running? if runs under account logg-in sql , call store, should access file. it's not. turns out credential substituted own. after search quite long time, can't find answer. any on appreciated. this store execute ssis alter procedure [dbo].[execute_ssis_package] @folder_name varchar(100) ,@project_name varchar(100) ,@package_name varchar(300) --,@runaccount varchar(300) output ,@output_execution_id bigint output begin set nocount on; declare @execution_id bigint exec ssisdb.catalog.create_execution @folder_name, @project_name, @package_name, @use32bitruntime = t...