Create PDF document in SQL

Question

I am writing a stored procedure in T-SQL that sends mail. I am looking to add an attachment to these emails. I have an html string that I would like to convert to pdf and attach to my email.

I am using selectPDF to convert my html to pdf.

Can this all be done in sql or do I have to write an application for creating the pdf document?

you probably could do it with a complicated CLR proc that was written in asp.net. But at that point you're writing it in ASP.net in a more complicated manner than it would be just to do it via a process that didn't involve sql email. — Kritner
– Kritner, Commented Jul 15, 2015 at 14:52

Matt · Accepted Answer · 2015-07-15 17:54:07Z

1

I've had good luck with iTextSharp in the past. iTextSharp Project

You would be looking at a wrapper CLR function around that, but yes it can be done.

As a side note too you could also design a SSRS report and automate that too...

answered Jul 15, 2015 at 17:54

Matt

1,4411 gold badge15 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Matt Over a year ago

Not a problem, glad I could help.

Collectives™ on Stack Overflow

Create PDF document in SQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related