Hi, I need help please. I have several tasks, with a lot of error checking with sending email on each task failure. This worked fine because i had a variable in row count & pass the entire row to a csv file. So i could see the entire record. But I had to many emails with different error csv files. I would like one error txt file for all the errors, so it appends the file with all the errors. but now i wont have control of the field error, but at least show the line no with it's value. Please Assist! Regards
Hi, You can use SSIS logging. Add SSIS log provider for Text Files as provider type, and add event OnError in order to log error to the file.
Thank You for the assist, tried but unsuccessful. I tried creating one csv file with columns based on expressions, add a derived column & add rows it works for one task but then on another task it overwrites the file, tried using raw file destination & append but that does not work. How do i in derived column, capture the record line in expression? Regards