[Note] This error happens when you have created a table with different columns containing different data type and you try to import data mapped to the column with different data type. In the video below, you will see I demonstrated with importing data to a table with changed column data type.
Data Flow Task 1: Data conversion failed,Sql Server Import Wizard Error