Actually I have tested it. I have saved it into another table and the package name is there. It is also a System variable in the SSIS package itself, so...

In the SSIS Execute SQL task I have the following:

EXEC SSIS_MGMT.dbo.LogPackageEnd

@PackageLogID=?

, @BatchLogID = ?

, @EndBatchAudit = ?

, @PackageName = ?

And I have set the System::PackageName as the fourth parameter.

Under ideal conditions I pass a parameter @PackageName.

If I use @subject = @PackageName, no mail is received

If I use SET @P = @PackageName

and then use @subject = @P, no...