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 ...