Sunday, January 30, 2011

System variables in SSIS

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"

Saturday, January 22, 2011

SSRS Templates in VS 2005 & 2008

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.