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