Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Wednesday, May 1, 2013 1:29 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 27, 2014 8:39 AM
Points: 13, Visits: 122
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


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:58 PM
Points: 35,792, Visits: 32,473
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

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

Add to briefcase

Permissions Expand / Collapse