title: How to overcome vs_needsnewmetadata error in Data Flow task?
body: <p>I have an SSIS package that copies the data in a table from one SQL Server 2005 to another SQL Server 2005.  I do this with a "Data Flow" task.  In the package config file I expose the destination table name.</p>
  
  <p>Problem is when I change the destination table name in the config file (via notepad) I get the following error "vs_needsnewmetadata".  I think I understand the problem... the destination table column mapping is fixed when I first set up the package.</p>
  
  <p>Question:  what's the easiest way to do the above with an ssis package?  </p>
  
  <p>I've read online about setting up the metadata programmatically and all but I'd like to avoid this.  Also I wrote a C# console app that does everything just fine... all tables etc are specified in the app.config ... but apparently this solution isn't good enough.</p>