title: SSIS package execution succeeds but doesn't do its job
body: <p>I use SQL Server Agent to fill tables in DataWarehouse. I have about 50 steps in the job and every step is run with a proxy account. And every step works correctly besides one:</p>
  
  <p>SSIS package which contains about 20 Execute SQL Tasks which execute procedure. This is what I have in the Execute SQL Task:</p>
  
  <pre><code>DECLARE @RC int
  
  DECLARE @fordate datetime = null
  
  DECLARE @tablename sysname = 'D_ENTITY'
  
  DECLARE @dataFolder varchar(1024) = 'C:\MountPoints1\src_etl\'
  
  DECLARE @logFolder varchar(1024) = 'C:\MountPoints1\src_etl\'
  
  DECLARE @debug bit = 0
  
  EXECUTE @RC = [dbo].[ETL1A_HR] 
   @fordate
  ,@tablename
  ,@dataFolder
  ,@logFolder
  ,@debug
  GO
  </code></pre>
  
  <p>The thing is, that if I execute the package from the SSIS catalog, it works ok. But if it is run by job, it succeeds, but only deletes from tables, but doesn't fill it. It seems like the procedure stops somewhere in the middle.</p>
  
  <p>Any ideas?
  Please advise, it took me days trying to solve this...</p>