When importing data retrieved via a query using the SQL Server Import and Export Wizard in SQL Server 2012, the VARCHAR Type is recognized as "200" while NVARCHAR Type as "202". This cause the wizard to show "Review Data Type" warning/error that looks similar to the following:
Found 14 unknown column type conversion(s)
You are only allowed to save the package
This means that the data transfer cannot be executed and the wizard will only be able to save the transfer as an SSIS package.
The issue seem to only appear if the data source is a query - i.e the "Write a query to specify the data to transfer" in the Specify Table Copy or Query section of the SQL Server Import and Export Wizard.
Choosing "Copy data from one or more tables or views" option in the Specify Table Copy or Query section seems to recognize the VARCHAR and NVARCHAR data type properly.