Post reply

Export query results to a pipe delimited text file

  • September 5, 2014 at 10:48 am

    #298987

    How?

    I've got a query that returns the data I need. I want to put the query in a stored procedure such that, when the SP runs I get a pipe delimited text file on disk. I don't really want to mess with SSIS, etc. Is there a Q&D way to do this?

  • September 5, 2014 at 11:17 am

    #1743584

    You could use the bcp utility through xp_cmdshell.

    Check the links for information on those.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

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

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