title: SQL Job completes successfully but does not execute packages
body: <p>I have taken a look at several articles including this unanswered question: <a href="https://stackoverflow.com/questions/34161158/sql-server-job-runs-successfully-but-doesnt-execute-packages">SQL Server Job runs successfully but doesn't execute packages</a></p>
  
  <p>I have the exact same problem in SQL Server 2012 using the integration services MSDB catalog.  I can execute the SSIS packages manually from that catalog, but the agent job doesn't do anything except state that it completed successfully.  I have also executed my SSIS packages from within Visual Studio and they worked just fine.  Here's the situation and am wondering if it may be permissions:</p>
  
  <ol>
  <li>SSIS packages look for Excel files matching criteria in a network location.</li>
  <li>Once found, the SSIS packages writing the data into the database and archive the file to another folder on that same network location.</li>
  <li>Emails are sent upon any failure of import of data into the database or migration into the archive folders.</li>
  </ol>
  
  <p>I have the SQL Agent job running the SSIS packages from a package store (MSDB) using the SQL Server Agent Service Account to run under.  Currently we are not doing any sort of project deployment to these servers so I am sticking with package deployment.  Here are some steps I've taken:</p>
  
  <ol>
  <li>Run packages manually from Visual Studio 2010 (fully successful).</li>
  <li>Run packages manually from SQL Server MSDB catalog (fully successful).</li>
  <li>Run job manually from SQL Server Agent using parent package as a step that will execute child packages as an external reference (success but nothing happens).</li>
  <li>Run job manually from SQL Server Agent using each package as its own step excluding the parent package (success but nothing happens).</li>
  </ol>
  
  <p>Any ideas?  Permissions to the network location or need a proxy?  Again, I am running Microsoft SQL Server 2012 Enterprise Edition 64-bit.  Many thanks for any help you can provide.</p>