Thanks Steve

You cannot do it using functions in sql server.

Thanks for ur immediate reply.

Yes i am not able to connect to a developer edition instance from within a database project

VSTE does not work with the developer edition of sql server 2005. this is what we found out. Not sure if this is because we did not install either of...

Thanks, but this does not really give the disadvantages.

Thanks All for you reply. This issue was resloved. i was trying to BCP out on a logical drive which  was mapped correctly. but then my network admin told me...

Thank you for your reply. my problem is resolved

Thanks a lot!

Could you forward me the web site links

I am unable to write one select statement to join all the tables. so what do u think?

do u have any script where in u have implemented this?

If I do as you mentioned ie create temp tables and then use DTS. but in my product we have like 185 tables. hence I will have to create 185...

But can DTS tranform multiple tables(with varying schema) to one single file. i.e does it append the result of transformation of multiple tables to one file.

Exporting the data from amny tables to one single file