export a table from a stored procedure not a DTS

[sandvenom]

I am trying to export a table directly from a stored procedure, with out calling for a DTS is there a way?

If any one has any suggestions it would be very appreciated

Thanks!!!!!!

 

[tlbroadbent]

No way exists to directly write to a text file from a stored procedure. There are several ways to indirectly output text from a SP. Check the info in the SQL FAQ at

http://www.swynk.com/faq/sql/sqlfaq_development.asp#FlatFile

Why not use DTS? Terry Broadbent

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[xcata]

You may use one system extended stored procedure xp_cmdshell. This procedure allows you to gain access to system commands so what do you want.
Another way is to use sp_OaCreate who permets you to create com objects so you may use windows scripting host to acomplish your task.