title: Why doesn't SSIS recognize tab column delimiters while importing into a database?
body: <p>I am trying to use an SSIS package to transfer data from a .dat flat file to a SQL Database table. I have a dat file that looks like this:</p>
  
  <pre><code>Booth 1 Weekly  Status
  Status  Date    Time    Operator    NESHAP  HEPA    Alarm
  Initial Reading 10/3/2011   7:42 AM Ken Forsberg    0.00    0.00    No
  System Reading  11/12/2011  3:10 AM System Log  0.24    2.01    No
  
  No Login    11/12/2011  7:00 AM     0.24    2.03    Yes
  No Login    11/12/2011  3:00 PM     0.24    2.03    Yes
  No Login    11/13/2011  7:00 AM     0.24    2.04    Yes
  No Login    11/13/2011  3:00 PM     0.24    2.02    Yes
  No Login    11/14/2011  7:00 AM     0.24    2.06    Yes
  No Login    11/14/2011  3:00 PM     0.24    2.05    Yes
  No Login    11/15/2011  7:00 AM     0.24    2.06    Yes
  No Login    11/15/2011  3:00 PM     0.24    2.04    Yes
  No Login    11/16/2011  7:00 AM     0.24    2.05    Yes
  No Login    11/16/2011  3:00 PM     0.24    2.05    Yes
  No Login    11/17/2011  7:00 AM     0.24    2.07    Yes
  No Login    11/17/2011  3:00 PM     0.25    2.10    Yes
  No Login    11/18/2011  7:00 AM     0.25    2.09    Yes
  </code></pre>
  
  <p>But when I run the Flat File Connection Manager Editor</p>
  
  <p>I have this for general:</p>
  
  <pre><code>Locale English(United States)
  Code page 1252 (ANSI - Latin I)    
  Format: Delimited    
  Text qualifier: none    
  Header row delimiter: {CR}{LF}    
  Header rows to skip: 0    
  Column names in the first data row: checked
  </code></pre>
  
  <p>And for the Columns I have:</p>
  
  <pre><code>Row delimiter: {CR}{LF}    
  Column delimiter: Tab {t}
  </code></pre>
  
  <p>But in the Preview window it only shows one column</p>
  
  <pre><code>StatusDateTimeOperatorNESHAPHEPAAlarm    
  InitialReading10/3/20117:42 AMKen Forsberg0.000.00No                
  System Reading11/12/20113:10 AMSystem Log0.242.01No    
  NoLogin11/12/20117:00 AM0.242.03Yes    
  NoLogin11/12/20113:00 PM0.242.03Yes    
  ...
  </code></pre>
  
  <p>I have the row delimiter as <code>Carriage Return</code> and <code>Line Feed</code> and the Column delimiter is <code>Tab</code> but as you can see the tab is not being recognized.</p>
  
  <p>I did open the .dat file in Notepad++ to confirm that they are delimited by Tab and they are.</p>
  
  <p>What am I doing wrong?</p>