This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The SourceTranslateChar property specifies whether to perform character data translation on the source server during a transfer operation.
Performing character data translation during a transfer operation can significantly impact server performance if a large amount of data must be translated. The SourceTranslateChar property is set to TRUE by default.
Set the DestTranslateChar property to TRUE to perform character translation on the destination server.
Set SourceTranslateChar to TRUE to resume character translation on the source server.