August 11, 2009 at 2:09 am
Hi
I hope this is right place to post my query regarding SSIS language translations *first post*
I have underlying table representing a dimension of our DW, in that there are 3 columns which hold data in french. We want to display data in english as well so after research on internet and consulting with experts 3 columns were added to this dimension table.
I created one package(filename.dtsx) to load data in this dim table which I assume will load data in 3 columns (French), and other 3 English columns would be loaded using Process option for dimension under my analysis services project i.e. (filename.dim).
I've added language translation for those columns, but when I process it nothing happens my underlying table table has null values in these columns for all rows.
Can someone please shed some light what wrong am I doing here?
I tried to understand language translation alot but couldn't find much info for Adventure WorksDW db provided by Microsoft
I hope I'm clear in my query...
Thanks in advance,
Satish.
August 11, 2009 at 8:11 am
Think of Translations as a big CASE statement. CASE Language
WHEN 'French' THEN [French Description]
WHEN 'English' THEN [English Description]
WHEN 'Spanish' THEN [Spanish Description]
etc.,
Translations simply picks which columns to display based on the desired language. It does not do any actual translations. If you want the English columns to populate, you're going to have to somehow provide the English values yourself.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply