Post reply

how to modify sql job to remove extra information coming in text file

  • July 11, 2013 at 2:51 am

    #1631497

    Run the job as a CmdExec job that runs sqlcmd that directs the output to the desired file. Include SET NOCOUNT ON to get rid of "1 rows affected".

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

Viewing post 1 (of 2 total)

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