SQLTeam.com | Weblogs | Forums

How can I add the server name to the subject line of a SSIS subscription email?


#1

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?


#2

If you are using Enterprise edition, you can convert the subscription to data driven subscription and set up the subject line using the data from the server, anyway you like. Otherwise, I don't know of a way to get the server name into the subscription subject line.