Asked By mayayana
21-Mar-07 09:52 AM
I don't know anything about "SQL Server 2005
Integraton Services" so I don't know how you're doing
it. I assume that you want a simple solution like
OtherComponent.AddFileToThisEmail
I can't offer any help in that case.
If you actually want to do it "by hand" you can.
It requires converting your binary file to Base64 and
then adding that text to the end of the email. The format
varies slightly depending on whether you actually want a
displayed image or an attachment. That approach
can be done without needing any extra component, but it
requires getting into the details of email structure.