N West
N West

Reputation: 6819

How does SSIS convert DT_WSTR to DT_STR?

What is the methodology that the SSIS data conversion transformation 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?

Upvotes: 1

Views: 7439

Answers (1)

Michael Entin
Michael Entin

Reputation: 7764

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

Upvotes: 2

Related Questions