Another BI & Programming Blog - Jason Yousef

As part of my confirmation e-mail after a successful package run; I enclude some expressions in the body of the mail message. 2 or 3 of them are using the system variables that already comes out of the box in SSIS Such as: "Package Name: " + @[System::PackageName]   + "\n"+ "Was executed at:  " +  (DT_WSTR, 40) @[System::StartTime] + "\n" + "Package Duration: " + (DT_STR, 6 , 1252) DateDiff ("ss", @[System::StartTime], GetDate())+ " Seconds"

The process is about creating a new template report, just an empty one, including the header photo and some of the built in fields. then saveing the .RDL file at C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject\     if you’re using VS 2005   Or C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject\       if you’re using VS 2008 Using the template: I usualy save 2 templates, I call them "ComapnyName_Template_Landscape"  and "ComapnyName_Template_Portrait" Download my sample .RDL template.