I am sure that most of us facing this problem, while extract data from Excel source.
As my experience, I don’t see any other alternative than two step conversion that is
Unicode text stream [DT_NTEXT] à Unicode string [DT_WSTR] à string [DT_STR]
The following images will explain the real scenario:
any idea about need to import more than 30,000 charecters?
ReplyDelete