title: Why did my SSIS package complete with an error while there seems to be no errors?
body: <p>I have a package with one data flow task. In the data flow task it copies data from one database to another archive database.</p>
  
  <p>I linked two precedence constraints. If it's successful it should go on and start a certain job in SQL Server (delete records from the original database). If the task fails, it should return a script task saying that it failed.</p>
  
  <p>When I run this, the data flow task is successful (every record gets copied). The data flow task gets a green tick. The <code>"execute SQL Server Agent Job Task"</code> also gets a green tick. Yet after completing the package it says </p>
  
  <blockquote>
    <p>"Package execution completed with error. Click here to switch to design mode, or select Stop Debugging from the Debug menu."</p>
  </blockquote>
  
  <p>I included a screenshot of it: </p>
  
  <p><img src="https://i.stack.imgur.com/CnkBC.png" alt="enter image description here"></p>
  
  <p>The output basically only says:</p>
  
  <blockquote>
    <p>SSIS package "c:\Users\Kim\Documents\Visual Studio 2012\Projects\POC\POC\Archive.dtsx" finished: Failure.</p>
  </blockquote>
  
  <p>So:</p>
  
  <ol>
  <li><p><strong>Where can I find the error?</strong> There is no indication at all what went wrong. Both show green ticks and the migration of data did went well indeed. The SQL Server job didn't do its job. The records are still there. So I have a feeling that the error has to do with the job. I have to mention it is the Change Data Capture cleanup job which was automatically made when I turned on CDC on this table. I did this because I only want this job to happen when the data flow task is successful (instead of running the schedule by default). </p></li>
  <li><p>If it failed, why didn't it follow the precedence constraint for failure (showing the script)?</p></li>
  </ol>
  
  <p>SQL Server agent is turned on by the way. </p>
  
  <p>Can someone please help me? I googled <code>"Package execution completed with error"</code> and I literally get only 68 results which are not helping. </p>
  
  <p>Kim</p>