I am trying to replicate this in my environment, using my own tables. Can you post the set up of the flat file connection manager (General and Advanced tabs)?

You can obfuscate the names, just make sure the data types, column properties, and all the formatting information are the same.

Are you saving to a file that ends in ".xml" or does it end in ".txt" or ".csv"? (Your screen shot has 2 flat file connection managers, I want to make sure which one the flat file destination is using).

And do you absolutely need the BINARY BASE64 definition in your XML? That's very specific to making your XML results return a base 64 binary format. That is probably the source of the datatype change errors. Does your code retrieve binary, varbinary, or image datatypes from the database?