outputting the Stored Proc output to Text File Pipe (|) Seperated with Headers

  • Command to run

    Exec Rpt_OrderReport '1/1/2013' , '1/31/2013'

    Need a code which will save the output to Text file with headers and column data pipe (|) seperated.

  • skb 44459 (3/18/2013)


    Command to run

    Exec Rpt_OrderReport '1/1/2013' , '1/31/2013'

    Need a code which will save the output to Text file with headers and column data pipe (|) seperated.

    Why not use SSIS? You can try bcp out, if your sp is trivial select (not using temp tables) then it will also work without changes in sp.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply