Post reply

Need output of a job in comma-delimited format

  • July 16, 2008 at 2:55 pm

    #191024

    Hi,

    We have a job which runs simple select and saves aoutput to a file in flat format. Now we need to change it to comma-separated , is it possible ? I tried to find it but it does not seem like possible.

    Thanks

  • July 16, 2008 at 8:51 pm

    #844120

    Mark Shvarts (7/16/2008)

    Hi,

    We have a job which runs simple select and saves aoutput to a file in flat format. Now we need to change it to comma-separated , is it possible ? I tried to find it but it does not seem like possible.

    Thanks

    Can you please shed some more light? How does Agent job save outputs to a file (via SQLCMD or SSIS package)? SQLCMD has parameter -s, which will help you.

    Regards
    Shrikant Kulkarni

  • July 17, 2008 at 7:43 am

    #844387

    No, I don't have SSIS or SQLCMD for this. The job is much simpler. In the body of a step1 I have a Select statement, and in advanced section I specify an output file which is on the same box. The file looks exactly as it would appear in SSMS query output window. But we got a recent requirement to change it to comma-delimited format, that's all.

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

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