I'm using SSIS to import an Excel table into SQL Server.
The field in the SQL Server table is set as nvarchar(max) but it still gives me Truncate Error. 
The column that I want to import can have any number of characters, it could be 1 or it could be 10,000. It's a free-text filed without any limitations.

[![enter image description here](https://i.stack.imgur.com/b8LWz.png)](https://i.stack.imgur.com/b8LWz.png)
[![enter image description here](https://i.stack.imgur.com/v5aQH.png)](https://i.stack.imgur.com/v5aQH.png)