title: How to open Advanced Editor for Flat File import in SSMS?
body: <p>Importing a CSV - I get a truncation error</p>
  <blockquote>
  <p>Error 0xc020902a: Data Flow Task 1: The &quot;Source - Train_csv.Outputs[Flat File Source Output].Columns[&quot;Title&quot;]&quot; failed because truncation occurred, and the truncation row disposition on &quot;Source - Train_csv.Outputs[Flat File Source Output].Columns[&quot;Title&quot;]&quot; specifies failure on truncation. A truncation error occurred on the specified object of the specified component.</p>
  </blockquote>
  <p>I used a method from <a href="https://stackoverflow.com/a/18600571/16364945">this answer</a> and sadly got another error. So I have tried using <a href="https://stackoverflow.com/a/28628046/16364945">this answer</a>.</p>
  <p><strong>Problem that I encounter</strong>
  I am unable to open the advanced editor. I cannot see this button anywhere.</p>
  <p>What I've tried to solve it</p>
  <ul>
  <li>googling</li>
  <li>youtube</li>
  <li>stackoverflow</li>
  <li>help in SSMS,</li>
  <li>opening the import tool from start menu and going to advanced tab.</li>
  </ul>
  <p>I'm running out of ideas here. Specifically, I don't know what to click in order to find the menu from no 2 on the picture below:</p>
  <p><img src="https://i.stack.imgur.com/3OYS9.jpg" alt="" /></p>
  <p>**Edit:
  This error is copy pasted from the ANSWER 1, as it's basically the same what I get, just different columns there.</p>
  <p>Also, answering Brad's question:
  <a href="https://i.stack.imgur.com/H48VP.png" rel="nofollow noreferrer">A view from my SSMS after right click</a>
  **</p>
  <p>Edit2: <strong>Possibly solved</strong></p>
  <p>AlwaysLearning said in the comments that this menu is not present in SSMS but in SSIS. I have been trying to google where to get it but I seem to be to tired to deal with it for now, therefore I will wait for others to confirm it or go back to it tomorrow. After I've found it in SSIS, I will make an edit here. T</p>