aaron.reese (7/23/2013)
Im not clear on the requirement.Are you saying that you have two files one English and one French
English:
Day|PartNo|Price
Monday|ABC|123.45
Tuesday|ABC|124.78
...
And in French
Jour|PartNo|Combien
Lundi|ABC|123.45
Mardi|ABC|444.55
If so, then firstly the files should not contain language specific data; the days should be 1,2,3,4,5,6,7 but if they do then I would set up a lookup table in the database to take those text values and translate them in the SSIS dataflow.
Lang|Descr|TargetDesc
EN|Monday|Monday
FR|Lundi|Monday
ES|Lunes|Monday
etc...
Thanks.
Yes it would be nice if the source data contained codes rather than text, but unfortunatly thats not the case. I've decided to do basically what you said. I will receive the files in their native language and translate any of these fields back into english via lookups at the staging phase.
If i have 20 such fields in some source data is it practical to have 20 individual lookups within a dataflow? Is there a better approach?