Hi
How can I call the bcp from Stored procedure and generate text file ?
thank you in advance
Printable View
Hi
How can I call the bcp from Stored procedure and generate text file ?
thank you in advance
Hi
You can run the bcp command through ESP xp_cmdshell.
For example, inside your stored proc, add the following sql command
exec xp_cmdshell 'bcp dbname..table out filename.bcp .....'
cheers
Joe
------------
mutley at 5/22/2002 11:50:20 AM
Hi
How can I call the bcp from Stored procedure and generate text file ?
thank you in advance