Create Text File and insert it into database

Hi

How can I create a text file (with my own file extension), populating it
with a few values from our database using a stored proceedure and naming it
using a field from the database.

Any advice would be much appreciated.

Thanks
Ben

Hi

There are many ways to do this, including DTS, or using xp_cmdshell to run
BCP, osql/isql or echo statements.
These may help <a rel="nofollow" style='text-decoration: none;' href="http://www.sqldts.com/default.aspx?292" target="_blank">http://www.sqldts.com/default.aspx?292</a>
<a rel="nofollow" style='text-decoration: none;' href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_4jxo.asp" target="_blank">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlr...ts_xp_a</a>
<a rel="nofollow" style='text-decoration: none;' href="http://tinyurl.com/56ojv" target="_blank">http://tinyurl.com/56ojv</a>
You may want to search google for other examples.

John

"Ben" wrote in message

 > Hi
 >
 > How can I create a text file (with my own file extension), populating it
 > with a few values from our database using a stored proceedure and naming
 > it using a field from the database.
 >
 > Any advice would be much appreciated.
 >
 > Thanks
 > Ben
 >