How can I add the server name to the subject line of a SSIS subscription email?
In Microsoft SQL Server Integration Services (SSIS) RDL report files uploaded are often set with the ability to send out periodic email alerts. On the SSIS 2008 system, this is called "Subscriptions". When a new email alert is set up, there are system defined strings in the Subject line which is presented as default as:
@ReportName was executed at @ExecutionTime
How can I add a new item to this subject line for the server name?