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"