Is it possible to add signature to send mail task? Or any other way to do that through SQL?

You could use Chilkat to send your emails with signatures. All you need to do is use a Script Task to create and send your emails. http://www.chilkatsoft.com/p/p_276.aspJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

Jeff, Thank you but the question was about adding signature using native SSIS or T-SQL and not third-party tools.

One suggestion thought i havent tried it myself, I assume you send an Email using the Outlook client, installed on the server where your package reside. Can you try setting up signature for the account which runs the packages, in the Outlook very similar to as you would have setup your signatures on Outllok. This might show same behaviour as when we open a new email, so when the SSIS account triggers the Oulook client the signature gets auto inserted. Also if you dont want to do above why dont you build your Email body with signature i assume signature is static and is not bound to change, if siganture is dynamic, declare a user variable var1 = Email Body + Sigantures are appened and use the same var1 as Email body in the send mail task Abhinav

AB82, I will try the second solution you suggested and will be back with info soon. Thanks