How to generate html file and save to the file system

  • I just upgraded from SQL Server 2005 to SQL Server 2012 and had a procedure that dynamically builds html and uses xp_smtp_sendmail to send the email. One of the parameters for this procedure is @dumpmsg. This parameter allows you to save the html file to the file system. In SQL Server 2012, sp_send_dbmail does not have a parameter to save the html file to the file system. In 2012, how can I build and html file and save it to the file system? Can this be done in TSQL or do I need to use SSIS?

  • You could create a job that will use a Cmd Exec step to save the file. It'll save you a trip to SSIS.

    Although there's a great amount of unnecessary fear about it, you could use xp_CmdShell to export it using BCP or SQLCmd.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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