Loading the multilanguage data

Question

Loading the multilanguage data

sandeep_shetty

Valued Member

Points: 55
More actions
March 3, 2008 at 5:24 am

#378975

can we load the multilanguage(like french,english,chinese,etc) data ito the single table using ssis package.We are getting the data in different excel file for different language and that data as to be dsiplayed in the ssrs report?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Chinna SSCertifiable Points: 5408 More actions · Answer 1

HI sandeep ...

if all of ur data in the excel file are in one format nd same data sets n has column delimiters then you can do that ....if for ex

eng has rows as

abc,asjh,1213,01/02/2006

and the pther language has a dataset diff than this in the same excel then u can use conditonal split n script task if u have separate excel files with same row sets u can jus import into the table ....to be more specific post some sample data of diff languages so that i can wrk out for u ...

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman

sandeep_shetty Valued Member Points: 55 More actions · Answer 2

the data are in the same format but after loading the data into the table.it shows junk character for the chinese data and we are able to read the other language data.how to overcome this and how to display this data in the single report?

Chinna SSCertifiable Points: 5408 More actions · Answer 3

could u jus post me some sample data of chinese language so that i can check as i believe we need to change some changes when importing plz post some sapmle data i shall tey n let u know ...

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman

Chinna SSCertifiable Points: 5408 More actions · Answer 4

hey post the sample data of chinese so that i shall try n see where the problem is n let u know

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman

Chinna SSCertifiable Points: 5408 More actions · Answer 5

hey sandeep

when u see the souce display screen with browse and locale in locale u can change the language and next to that u will have unicode did u check that or unchecked it that because of that u may get that way ...is ur excel file stored as a string or unicode....let me know if u solved the issue even let me know how u did that ....

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman

sandeep_shetty Valued Member Points: 55 More actions · Answer 6

sandeep_shetty

Valued Member

Points: 55

March 3, 2008 at 11:27 pm

#784788

the strings in the excel file are unicode.

Chinna SSCertifiable Points: 5408 More actions · Answer 7

hey sandeep if u dnt mind post few rows of sample data of other languages so that i can give a shot ....n llet u know

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman