title: Text was truncated or one or more characters had no match in the target code page When importing from Excel file
body: <p>I have an excel file with four text columns:
  one of them is called ShortDescription which has the longest value.
  I created a table in SQL Server 2008 database, with four columns and the ShortDescription column type is set to NvarChar(Max).</p>
  
  <p>but when using the SSIS import and export dialog, I keep getting the mentioned error in the title, even when I set the OnTruncation option to Ignore.</p>
  
  <p>I tried to clear the column data, and it succeeded (so I made sure that the problem is in the ShortDescription column). 
  I tried to copy the whole data  to another excel work book, and still no luck.</p>
  
  <p>any ideas ???</p>