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
"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"
Sunday, January 30, 2011
Saturday, January 22, 2011
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
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.