title: Using T-SQL to execute SSIS package does not return any result
body: <p>I have a simple SSIS package that uses C# to generate an Excel file and put it to assigned location.</p>
  
  <p>Package works fine in design mode. </p>
  
  <p>Package been deployed successfully:</p>
  
  <p><a href="https://i.stack.imgur.com/b3R6i.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/b3R6i.png" alt="enter image description here"></a></p>
  
  <p>However when I try to execute it from SSMS - then then its only displays <code>@execution_id</code>. </p>
  
  <pre><code>DECLARE @execution_id BIGINT
  
  EXEC [SSISDB].[catalog].[create_execution] 
          @package_name=N'ExcessCopy1.dtsx',
          @execution_id=@execution_id OUTPUT,
          @folder_name=N'MonthlyReports',
          @project_name=N'MonthlyReports',
          @use32bitruntime=False,
          @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><a href="https://i.stack.imgur.com/5h4VN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5h4VN.png" alt="enter image description here"></a></p>
  
  <p>If I comment out <code>SELECT @execution_id</code>, then I get</p>
  
  <blockquote>
    <p>Command completed successfully</p>
  </blockquote>
  
  <p>However it does not deliver file to assigned location.</p>
  
  <p><a href="https://i.stack.imgur.com/a8Q8O.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/a8Q8O.png" alt="enter image description here"></a></p>
  
  <p>What can be the problem and how can I troubleshoot this issue?</p>
  
  <p>I can see the package under Integrational Service Catalog. 
  But I was unable to find this package in SSISBD:</p>
  
  <p><a href="https://i.stack.imgur.com/mAWdn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mAWdn.png" alt="enter image description here"></a></p>
  
  <p>I was able to see what is the error:</p>
  
  <p><a href="https://i.stack.imgur.com/LMGwg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LMGwg.png" alt="enter image description here"></a></p>