How does SSIS convert DT_WSTR to DT_STR?
What is the methodology that the SSIS data conversion transform开发者_Python百科ation uses when converting a DT_WSTR to DT_STR? If a character exists in the DT_WSTR which does not exist in the destination code page of the DT_STR, will the mapping fail, or ignore the character?
I guess it uses WideCharToMultiByte or something similar.
You control what happens by setting truncation options, see http://msdn.microsoft.com/en-us/library/ms141679.aspx
精彩评论