SSIS Error: VS_NEEDSNEWMETADATA
<p>I'm currently updating all of our ETLs using Visual Studio 2015 (made in BIDS 2008) and redeploying them to a new reporting server running on SQL Server 2016 (originally 2008R2).</p>

<p>While updating one of the ETLs and trying to run on the new server I got this error:</p>

<hr>

<blockquote>
  <p>The package execution failed.  The step failed.</p>
</blockquote>

<p><strong>Sometimes it also produces this error:</strong></p>

<blockquote>
  <p>Source: Load Fact Table SSIS.Pipeline     Description: "Copy To Fact
  Table" failed validation and returned validation status
  "VS_NEEDSNEWMETADATA".</p>
</blockquote>

<hr>

<p>I've tried deleting and re-adding the OLEDB Destination, connection strings and opened up the column mappings to refresh the meta data. I also recreated the whole data flow task but I'm still getting the same error.</p>

<p>The package runs fine on my local machine.</p>

<p><strong>UPDATE:</strong></p>

<p>I started taking the package apart and running only pieces of it to try and narrow down which part was failing. It seemed to be failing on loading into the staging table but I couldn't find out why.</p>

<p>I eventually decided to just try and re-create the whole thing. After re-creating the entire package, still no luck. The picture below is from the event viewer on the server itself but it didn't give me any new information.</p>

<p><a href="https://i.stack.imgur.com/8na5d.png" rel="noreferrer"><img src="https://i.stack.imgur.com/8na5d.png" alt="enter image description here"></a></p>

<p><a href="https://technet.microsoft.com/en-us/library/cc627377(v=sql.105).aspx" rel="noreferrer">Package error from event viewer</a></p>