thkz adam but now i can use ssis so i dnt want to go for complexitu using scripts so when poss jus look over abt ssis thkz

hey adam the link u provied is good it is used to import data from multiple files automatically but in that i got a problem .. In xpression when i...

can i know how can i do that in ssis

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

so in the second operand do we need to write a query then bcoz he jus specified \\table 1 but what should be the query over could u jus give...

hey adam i have a doubt if i need to write the same logic using "cast" instead of convert how can i write that when i tried dnt that...

got it i understand now thkz a lot...adam..

The second query is saying to take the difference, in weeks, between the beginning of the month (3/1/2008) and today's date + 1 (3/4/2008).

The + 1 at the end is...

thkz got it i used in ssms may be that was the problem ...

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

hey jeff what i have asked is when i use the "0" in my statement i get an error as invalid column so how can i use that and why...

then why do i get an error as invalid column 0 plz let me know n uhavent said me abt dt_str y do we use that with that i get...

hey greg and adamm i have a ques its simple though ....

what is the use of "0 " in that when i tried to execute

right ("0"+ (dt_str,4,1252)right--------

it says invalid...

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

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