Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

How to generate html file and save to the file system Expand / Collapse
Posted Wednesday, May 1, 2013 1:29 PM


Group: General Forum Members
Last Login: Monday, January 18, 2016 10:04 AM
Points: 14, Visits: 155
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?
Post #1448590
Posted Wednesday, May 1, 2013 11:44 PM



Group: General Forum Members
Last Login: Yesterday @ 10:35 PM
Points: 42,070, Visits: 39,452
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."

Helpful Links:
How to post code problems
How to post performance problems
Post #1448694
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse