CODEWITHSUNDEEP
t-sqlpdfsp-send-dbmaildbmail
Diane2
Diane2

Reputation: 160

Create PDF document in SQL

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?

Upvotes: 0

Views: 1968

Answers (1)

Matt
Matt

Reputation: 1431

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...

Upvotes: 1

Related Questions