title: how to import flat file source to database using sql
body: <p>im currently want to inport my data from flat file to the database.</p>
  
  <p>the flat file is in a txt file. in that txt  file, i save a list of URLs. example:</p>
  
  <p><a href="http://www.mimi.com/Hotels-g303188-Rurrenabaque-Hotels.html" rel="nofollow noreferrer">http://www.mimi.com/Hotels-g303188-Rurrenabaque-Hotels.html</a></p>
  
  <p>im using the SQL Server Import and Export wizard to do it. but when the time of execution, it has error saying</p>
  
  <pre><code>Error 0xc02020a1: 
  Data Flow Task 1: Data conversion failed. The data conversion for column 
  "Column 0" returned status value 4 and status text "Text was truncated or one 
  or more characters had no match in the target code page.".
  </code></pre>
  
  <p>can anyone help?..</p>