Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
whizsql
Starting Member
17 Posts |
Posted - 2009-01-16 : 17:24:18
|
Hi,I am trying to configure send mail task on package event handler.The mail should include log file as an attachment.I assume, the first step to achieve this is to configure error outputs to a file.I am not sure how to configure error outputs for control flow tasks like prepared SQL tasks which truncates destination tables in a SSIS default import export package prior to data insert.Also, I want to maintain a single log file for all errors resulting from control flow tasks and dataflow tasks.How can I achieve file append.It would be helpful if you can guide me on configuring error output.I have configured logging to a SQL Server table.As an alternative, would I be able to use expressions to fetch from log table and sent them in a mail.Which approach is better? Since I am new, I dont know how to get these done on a SSIS package.Please help. |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-17 : 02:20:50
|
yup. its possible to use expressions to fetch from log table and sent them in a mail. you can use expression builder for that. just use variable to hold the fetched value and map it to appropriate property of sent mail task using expression builder |
 |
|
whizsql
Starting Member
17 Posts |
Posted - 2009-01-19 : 16:38:59
|
Thanks for your response.SinceI am new to SSIS ...it would be great if you can explain expressions that fetch records from log table.In the mean time, I configured Send Mail task on, package on error event handler and used system variables to build an error message message.But, when I execute the package it sends out mail for every error whithin the package..Is there any way, I can club these errors together and post it in a single mail? Also, the error messsage I built using system variables are not very convincing..it just provides generic information.I appreciate your help. |
 |
|
|
|
|