We are using SSIS, Transfer SQL Server Objects Task Editor to move data from one SQL Server system to another.
A few of the records on the source system have unprintable characters in them. Yes, it would be a goal to clean that up, but since that involves application changes, our current objective is to have the data transferred so it matches exactly between the systems.
It appears on these records that the unprintable characters are not transferring to the target system. Then when something like Data Dude (or whatever they call it now) is used to compare the systems, these records appear as mismatches.
Is there a way using SSIS, to get the data to copy from the source to the target exactly as the data exists?