Feeds:
Posts
Comments

Posts Tagged ‘event handler ssis send mail task’

Go to event handler, choose OnError

Drag a Send Mail Task

Configure SmtpConnection and other details except MessageSource

Go to Expressions tab and then expand this, then click on browse
button this will open Expressions designer

Choose MessageSource under Property window and then again
click on browse button this will open the second editor, the Expression
Builder.

Then substitute values in Expression window like below

"XYZ Job
Failed"+"!"+"\n"+"Error Details:"
+"\n"+"On Server – "+ @[System::MachineName]
+"\n\n"+"Package Name – "+
@[System::PackageName]+".dtsx" +"\n\n"+"Task Name(
Task where job failed ) – "+ @[System::SourceName]
+"\n\n"+"Task Type(SSIS Component) – "+
@[System::SourceDescription]+"\n\n"+ "Error Description –
"+@[System::ErrorDescription]+"\n\n"+ "Error Code – "+
(DT_WSTR, 12) @[System::ErrorCode]+"\n\n"

image

 

Read Full Post »

%d bloggers like this: