Post reply

Export query results to delimited text file from SQL Job?

  • December 7, 2010 at 6:37 am

    #141578

    I had a request to build an export routine with a SQL job without using SSIS. I see an option to output query results in the Job Step properties but this does not seem to provide an option for specifying how the file is delimited. Does anyone know of a way to do this and can point me in the right direction?

    Thanks!

  • December 7, 2010 at 6:50 am

    #1259506

    There are a number of ways but I would go with bcp if possible.

    If needed it will take a querry as input and if necessary you can format the row yourself.

    Also have a look at sqlcmd (replacement for osql).


    Cursors never.
    DTS - only when needed and never to control.

  • December 7, 2010 at 7:37 am

    #1259529

    i can get the BCP to create the export - thanks. I also created a format file but am not clear on how to specify the output to '|' delimited. any ideas? I think you were saying I could build the row myself concatenating everything manually with the '|', but i'd rather do something cleaner if possible. thanks

  • December 7, 2010 at 7:41 am

    #1259531

    Does it need a format fie?

    try -t|

    to specify the field terminator.


    Cursors never.
    DTS - only when needed and never to control.

Viewing 4 posts - 1 through 3 (of 3 total)

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