Home All Groups Group Topic Archive Search About

Store SQL BlobColumn as Attachment to MailMessage?

Author
15 Dec 2005 7:58 PM
Scott Townsend
I'm looking for a way to send an email attachment from the contents of a
BlobColumn.
We have table with a BlobColum that contains a PDF File. I'd like to be able
to send an email with that PDF file as an attachment. Is there a way I can
go directly from a variable of type
Microsoft.SqlServer.Dts.Pipeline.BlobColumn Directly to an Attachment
without having to save the file first?

If i need to save it to a file, what is the best way to do that?

Thanks,
Scott<-

AddThis Social Bookmark Button