write text files in transac sql

[raulgz]

Hi

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


Thanks,

[Simon Hayes]

"raulgz" <ra****@ozu.es> wrote in message
news:9b**************************@posting.google.c om...

Hi

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


Thanks,

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

[Erland Sommarskog]

raulgz (ra****@ozu.es) writes:

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

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, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[raul garcia zamarra]

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 ***
Don't just participate in USENET...get rewarded for it!