exporting SP result to a text file

[Guest]

I have a SP with three parameters coming from textbox of a form I would like
to execute the SP and export the result in a text file as an import source
for another software what is the best way ? I'm in an ADP

Thanks

FRED

 

[Guest]

uh you could do that with BCP and the command line

I tihnk that you can also use the BULK INSERT statement to export files; but
i dont know for sure

i use BCP for export and BULK INSERT for imports; for performance reasons