Thank you Orlando,

I got it but my team was fixed with SQl 2008.Thank you a lot for your help

Thanks,

Karthik

Thanks a lot Chris

Thank you Chris

Is there any other datatype other than DATETIME ....So that i can get the date not in the military format.

Thanks,

Krthik

Hi Phil Parkin,

Thank you for your response

I got it the thing is i wrote expressions for flat file connection(properties)

Thanks & Regards,

C Karthik

Hi Phil Parkin,

Actually in my scenario country1 contains records of AUstralia,Country2 contains records of Canada,Country3 contains records of France..........Country6 contains records of United States

I dont want to rename flat files...

Hi Eirikur Eiriksson,

Sorry Actually this is my first post.So i dont know how to post

Thnaks & regards

Karthik