Error 0xc02020a1: Data Flow Task 1: Data conversion failed "Text was truncated or one or more characters had no match in the target code page."

I'm trying to import a text file in my mssql database via SSMS import utility and it's throwing below error:

    Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data 
conversion for column "Notes" returned status value 4 and status text 
"Text was truncated or one or more characters had no match in the target 
code page.". 

Suggested solutions available on internet, I have changed the code page to 65001(UTF-8). However, after updating that,I'm getting this new error:

    Error 0xc02020f4: Data Flow Task 1: The column "LastName" cannot be 
processed because more than one code page (65001 and 1252) are specified 
for it.
 (SQL Server Import and Export Wizard)

Also, 'Edit Mappings' section isn't allowing me to increase column size as well.

any help will be appreciated in order to import my file

Here is the sample data which I want to import: EmployeeID,LastName,FirstName,BirthDate,Photo,Notes 1,Davolio,Nancy,1968-12-08,EmpID1.pic,Education includes a BA in psychology from Colorado State University. She also completed (The Art of the Cold Call). Nancy is a member of 'Toastmasters International'.

To import to a new table enter the name of the destination table (the one that will be created) for the Destination field and make sure there isn't already a table with this name in the database. Once a new name is entered, you can make modifications to the destination columns on the Column Mappings window that appears after the Edit Mappings button is pressed. In the following example, the name NewTableName was typed into this destination field and this will be the destination table. If you're having trouble locating the table in the destination database make sure the correct database is selected on the Choose a Destination page of the Import and Export Wizard. This is equivalent to the Initial Catalog property of a connection string, and you'll see the selected database there for the connection manager of the destination if you save the package and open it in SSDT.