Source Type 200 in SQL Server Import and Export Wizard?

With a bit of experimentation this error only seems to occur when you have a query as the source. The accepted answer did not work for me as copying to a flat file would result in the same error.

To solve this I put my query into a View then selected Copy From one or more Tables Or Views instead of Write a query....

I went through the wizard normally after that and my data went through with no error


Unfortunately this is a BUG. See (and vote up) links below:

--> SQL Server Import and Export Wizard Does Not Recognise Varchar and NVarchar

and

--> DTSWizard in SQL 2012 SP1 no longer recognizes nvarchar/varchar data types when source is a query