Let’s say your manager wants you to send summary information of the package (not just a one line message) that you’re running or even if there’s an error occurred during the package run. What will you do? I’m sure BI Express is a good option for this task, also you can create your custom message string and send it through send mail task and execute sql task by passing variable value. I want to see summary of the package run in email msg, please include following information: 1) Package Start Time 2) Package Completed with Success/Failure 3) Look up Match Records 4) Look up Not Match Records 5) Package End Time You can use the execute sql task in your package and create custom string using the sql code. After this step store the result set value as a single row and use the variable (SendMail) SELECT 'SSIS Started: ' + CAST ( ? AS VARCHAR ( 50 )) + char ( 10 ) + char ( 13 ) + 'Package Completed Succssfully' + char ( 10 ) + char...
-Make better business decisions