title: Validate SSIS packages for VS_NEEDSNEWMETADATA
body: <p>I'd like to automatically check my deployed packages for any metadata issues, such as if a column data length is increased from varchar(20) to varchar(60) before they're run. I encountered an error in the package at midnight and I'm hoping to catch it sooner.</p>
  
  <p><a href="https://i.stack.imgur.com/hs2pf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hs2pf.png" alt="enter image description here"></a></p>
  
  <p>I've tried both <code>[SSISDB].[catalog].[validate_package]</code> and <code>catalog.validate_project</code> but strangely they <em>don't</em> seem to catch this specific error. However, if I open up Visual Studio, the error shows up in the data flow component immediately without running the package.</p>
  
  <p><a href="https://i.stack.imgur.com/TfcmH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TfcmH.png" alt="doesn&#39;t work"></a></p>
  
  <p>Are there any methods to validate the package for metadata changes? </p>
  
  <p>Edit: Additonal information. This is an Oracle Source database so I'm using Attunity Oracle Source Connector.  I have DelayValidation set to False on the Data Flow Task and ValidateExternalMetadata = True on the Source component. </p>