Home Forums SQL Server 2008 SQL Server 2008 - General how to modify sql job to remove extra information coming in text file RE: 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]