Hi.,

Thanks for suggestion.,SSIS installed on my machine SQLserver 2005.,MS Excel 2007 is this problem But while saving Excel converted to Excel 97-2003..

please suggest to reslove...

Hi.,

Thanks for Reply., No reason behind using file system.,i don't have much idea about SQL Agent

I wanted to knw error Reason why it's coming?...

k thanks

hi thanks for your reply

table is same name but i m going to create view only in with same name...

thanks for your reply ps

i want do it on sql query analyzer only if it possible for this plz tell me what is the error and solution...