Inserting context of the file inside email message text

Here is very basic example of email automation

This is important feedback message stored on the file which must be passed to the supplier

Automation Package

Script Package Action

begin
 SetVariable('',FileToString('C:\tmp\text.txt'));
 Result:=True;
end;

Send Email Action

Variable Value after script execution is completed

About Variables

Variables are used to pass parameters between various objects. For example, SQL script has failed and you would like to email the SQL to the developer. Insert <Sql Script> Into email message and it will be replaced with actual SQL.

Note:

There are several ways to create variables

  1. Using script action
  2. Using transformation action
  3. Using calculation object within transformation action or package
  4. Using Set Variable Action
  5. Manually using Global Variables

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL forum

  • knowledgebase/inserting_context_of_the_file_inside_email_message_text.txt
  • Last modified: 13/04/2019 17:24
  • by admin