title: How to reconfigure the column information on a flat file connection manager?
body: <p>I have a Flat File Source that is reading data from a flat file. We have recently added a new column to this flat file.</p>
  
  <p>The flat file data is inserted into a database table. To accommodate the new field in the destination component, I used the <code>ALTER TABLE</code> statement to add the new column to the table. That is the only change I have done. </p>
  
  <p>Should the mapping between flat file and destination component automatically change? I do not see the additional column present in the flat file anywhere within the SSIS package.</p>
  
  <p>How do I configure the additional column in the flat file within SSIS package so that flat file source can pass the data to the destination component?</p>