title: SSIS Flat File Connector Not Working
body: <p>I'm getting the following error on every flat file connector I set up. The flat file connectors are set up from ADO.NET in a Data Flow Task</p>
  
  <blockquote>
    <p>Error at Data Flow Task [Flat File Destination 11 [1230]]: The number
    of input columns for Flat File Destination 11.Inputs[Flat File
    Destination Input] cannot be zero.</p>
    
    <p>Error at Data Flow Task [SSIS.Pipeline]: "Flat File Destination 11"
    failed validation and returned validation status "VS_ISBROKEN".</p>
    
    <p>Error at Data Flow Task [SSIS.Pipeline]: One or more component failed
    validation.</p>
    
    <p>Error at Data Flow Task: There were errors during task validation.</p>
  </blockquote>
  
  <p>I have verified that there are columns in the input, as follows:</p>
  
  <p><img src="https://i.stack.imgur.com/5eknS.png" alt="Flat file appears to be reading the columns correctly"></p>
  
  <p>My <a href="https://i.imgur.com/A1KbvWG.png" rel="nofollow noreferrer">data flow</a> looks like</p>
  
  <p><img src="https://i.stack.imgur.com/Vi5Pl.png" alt="enter image description here"></p>
  
  <p>Metadata looks appropriate</p>
  
  <p><img src="https://i.stack.imgur.com/ReuWD.png" alt="enter image description here"></p>
  
  <p>Column mappings</p>
  
  <p><img src="https://i.stack.imgur.com/D4ifr.png" alt="enter image description here"></p>