Does anyone know how to change the Importance flag on the tSendMail component at run-time. I've searched but cannot see any subjects or post on here or anywhere on Google.
Here's the scenario:
input file --> get counts --> remove duplicates --> add to SQL --> get SQL counts --> tJava (to do some calculations and construct the email body) --> send email And yes I'm using context variables to store certain information.
I have a job that has one tSendMail component. The job adds data to an SQL Server table. I count the number of records that are in the original file and then I have a count of the number of record actually added to the SQL table. It's possible for the original data to contain duplicate records. This is eliminated in the job so the count from the original records could be different to what actually goes into SQL. One way or another an email alert needs to be sent that the job has completed including a summary of the counts. What I need to do is change the 'Importance' of the email alert to 'High' instead of normal when the figures do not match. The default setting is normal. How do I change the Importance from normal to High at run-time? I'd prefer not to add another tSendMail component.
