Cannot convert unicode to non-unicode ssis OLEDB destination in SSIS
Solution : 1. add data conversion transformation in package as shown in bellow 2. Select field which you have problem and change data type to DT_STR and provide length as shown in bellow. 3. Repeat 2 nd step for bellow error 4. Repeat 2 nd step for bellow error 5. Execute package