call bcp from stored procedure
Results 1 to 2 of 2

Thread: call bcp from stored procedure

  1. #1
    mutley Guest

    call bcp from stored procedure


    Hi

    How can I call the bcp from Stored procedure and generate text file ?


    thank you in advance

  2. #2
    Joe Fung Guest

    call bcp from stored procedure (reply)

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •