title: SQL Server 2014 import truncation error
body: <p>I've had a reoccurring issue when importing csv/xlsx files that have a text field with a text length in the 300's or larger. For example in my file, Linkedin URLs which can get very lengthy. However, no matter what length I set the destination field to on import (400/MAX ect...) I always get a truncation error. I have seen workarounds like sorting the excel sheet by using a LEN() function and taking out the largest rows, but I need to maintain all of this data so this really isn't a good option. Is there any way to fix this? I haven't really seen anything explaining why this won't work.</p>
  
  <p><a href="https://i.stack.imgur.com/O9AxI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/O9AxI.png" alt="enter image description here"></a></p>