title: SSIS stuck on SP validation
body: <p>I have a complex process running from SSIS with several SPs.<br>
  The process has been working well for quite some time and now I'm mainly working on correcting the logic.</p>
  
  <p>This afternoon the process stopped working. I didn't receive any errors since the process didn't crash, it's just "stuck" on the validation. The last line in the output window is: <code>SSIS.Pipeline: Validation phase is beginning</code>. </p>
  
  <p>The part that it's validating is an SQL SP that I've adjusted today. The SP itself runs fine when I execute it from SSMS.</p>
  
  <p>Can someone give me an idea why it seems to be validating forever?</p>
  
  <hr>
  
  <p><strong>EDIT</strong></p>
  
  <p>After running the same process with a different set of data, I found that it runs without any problems. I didn't change any of the packages, just the data set.</p>
  
  <p>Could something in the data cause the validation to to hang?</p>