So, I've done some research and I can't seem to figure this out. I'm not sure if it's some setting that I'm missing or what.
For the basic info, running SQL2012, 64 bit, all that good stuff. I noticed that, for some reason, when I export from a table into a flat file using a query, the data type is defaulting to bytestream. In the past, it always defaulted to DT_STR and went through without any issues.
Here's the query:
SELECT pin from IncrementalDM_Emails where email in (select email from [7755_forsql]) order by pin
Here's the error I'm getting:
Here's what the export is showing when I select "Edit Mappings..."
Now, this can be easily fixed by simply selecting "DT_STR" under the Mappings dialog but I frequently export using this method so I'd like to find out why it's doing it and fix it so I don't always have to go into the Edit Mappings dialog.
Is it something to do with the query and the use of the
IN function? Any help would be greatly appreciated!
EDIT: The data in both tables is stored as varchar(50)