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 error get?


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

Popular posts from this blog

Reindexing

Users List

List of charts