title: Can not find the stored procedure error in SQL Server Agent job with ssis package
body: <p>An SSIS package which consists of an Execute SQL task is running fine when executed in the SQL Server 2014 catalog.</p>
  
  <p>When this is a part of a SQL Server agent job, it throws an error</p>
  
  <blockquote>
    <p>can not find the stored procedure</p>
  </blockquote>
  
  <p>The package's Execute SQL task contains the statement </p>
  
  <pre><code>exec usp_procedures
  </code></pre>
  
  <p>The definition of this stored procedure is to execute multiple other stored procedures:</p>
  
  <pre><code>exec usp_strdproc1
  exec usp_strdproc2
  exec usp_strdproc3
  exec usp_strdproc4
  </code></pre>
  
  <p>All of the sub procedures are accessing files in a particular location. I have ensured that the SQL Server agent job has all the permission to access the file</p>