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