title: SSIS pkg with flat-file connection with fewer columns will fail
body: <p>Assume a flat file F1.txt, Column MyCol1 and a package Pkg1 to load said file to SQL server.</p>
  
  <p>No problem, right? Right. </p>
  
  <p>Now assume a flat file F2.txt, Columns MyCol1, MyCol2 and the same package Pkg1 to load said file to SQL server. </p>
  
  <p>We'll make a few adjustments to Pkg1 and presto - it loads F2.txt like a dream.</p>
  
  <p>Now we feed it F1.txt and that's where things deteriorate.</p>
  
  <p>BTW, this does not confine itself to flat-files but is of a more general nature.</p>
  
  <p>Any and all suggestions on how to run legacy-data within the same package are welcome.</p>
  
  <p>TIA</p>
  
  <p>Peter</p>