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"
No comments:
Post a Comment