why can i NOT convert ANSI to UNICODE using `Data Conversion Transformation`
hello
i wondering point of transformation if can not convert between:
unicode - code page 65001
to
non-unicode - code page 1252
in image below tried converting unicode columns ansi - fails
is there configuration needed work?
i have use derived columns this; wonder transformation for.
many thanks
data warehouse | data migration | etl/elt | uk | http://www.brainpowered.net/cms
what source? if it's database, it's easier cast in source query: http://microsoft-ssis.blogspot.com/2011/01/cast-and-convert-to-avoid-data.html
please mark post answered if answers question | ssis blog: http://microsoft-ssis.blogspot.com | twitter
SQL Server > SQL Server Integration Services
Comments
Post a Comment