Formatting SSIS

[InSanity]

Hi,

I have a ssis package that sends an email, now i want to know is there any way that i can change the format of that email to include RTF(rich text format) instead of just using the default email properties

Any help?

Shot guys!

 

[Turbo_Aspiration]

I'm pretty new to SSIS myself. But I suspect you'll have to create your own custom script which sends mails using the conventional System.Net.Mail namespace. This could be populated using your SSIS variables.

I could be way off though

 

[Gothan]

I'm pretty sure SSIS *spit* use smtp to send mail ( and also mapi like the old dts from sql server 2000), would it not be easier to create your own rtf file and then just send as an attachment via smtp?

Unfortunately I use real etl tools like datastage and real databases like iq. But yes, you should be able to create an rtf file and then add it as an attachment, but that is as far as my nonsensical advice goes