title: SSIS package works from SSMS but not from agent job
body: <p>I've an SSIS package to load excel file from network drive. It's designed to load content and then move the file to archived folder.</p>
  
  <p>Everything works good when the following SQL statement runs in SSMS window. </p>
  
  <p>However when it's copied to SQL agent job and executes from there, the file is neither loaded nor moved. But it shows "successful" from the agent log.</p>
  
  <p>The same thing also happened to "SSIS job" instead of T-SQL job, even with proxy of windows account.(same account as ssms login)</p>
  
  <pre><code>Declare @execution_id bigint
  EXEC [SSISDB].[catalog].[create_execution] @package_name=N'SG_Excel.dtsx', @execution_id=@execution_id OUTPUT, @folder_name=N'ETL', @project_name=N'Report', @use32bitruntime=True, @reference_id=Null
  Select @execution_id
  DECLARE @var0 smallint = 1
  EXEC [SSISDB].[catalog].[set_execution_parameter_value] @execution_id,  @object_type=50, @parameter_name=N'LOGGING_LEVEL', @parameter_value=@var0
  EXEC [SSISDB].[catalog].[start_execution] @execution_id
  GO
  </code></pre>
  
  <p>P.S. At first relative path of network drive is applied, then switched to absolute path(\\server\folder). It's not solving the issue.</p>