Hi

I need create, write and read text files in a procedure transac sql
from sql server 2000
How i do this ??

[quoted text, click to view]

To read in a file of data to a table, you can use BULK INSERT, but
unfortunately there is no equivalent for writing out to a file. A common
solution is to use xp_cmdshell to call bcp.exe or osql.exe.

An alternative, if you have the appropriate permissions, is to use the
sp_OA% procedures to instantiate the FileSystemObject and read/write that
way. Or perhaps write an external script, then execute it using xp_cmdshell.

Simon

raulgz (ragaza@ozu.es) writes:
[quoted text, click to view]

In additions to Simon's response, I like to add that you should think
twice before you do this. If you are importing and exporting data,
that's alright. Use BULK INSERT or call bcp from xp_cmdshell. But if
you are up to something else, you should probably consider to do it
client-side.

--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at

Thank very much,

Really I need create txt files with dinamic
sql reading sql server catalog, the bettet solution
is create this files in client side.


Thanks again


RaulGZ.

*** Sent via Developersdex http://www.developersdex.com ***