Here is a very basic example of email automation

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

 Insert file1

Automation Package

Insert file2

Script Package Action

Insert file4

begin
 SetVariable('<FileData>',FileToString('C:\tmp\text.txt'));
 Result:=True;
end;
Send Email Action

Insert file5

Variable Value after script execution is completed

Insert file3

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 the 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

Download Free Trial of Advanced ETL Processor
Direct link, no registration required.