title: How to bypass SSIS VS_NEEDSNEWMETADATA error?
body: <p>I've created a SSIS package using the Import/Export utility from SQL Server to export data from a view to an Excel file. I've also scheduled it through a schedule in SQL Server and everything is working perfectly.</p>
  
  <p>The view that I'm exporting data from is actually taking data from multiple views and so on, for about 3 levels in "hierarchy".</p>
  
  <p>I'm encountering an error <code>VS_NEEDSNEWMETADATA</code> when I modify the column aliases of any of the views that go into the top level view, from which I'm exporting data.</p>
  
  <p>After research I understand that this is why I'm getting the error, but is there any way to "propagate" the metadata of the "new view" so I don't have to recreate the SSIS package everytime I make a change in the structure of the view?</p>