Here is very basic example of email automation

This is important feedback message stored on the file which must 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 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 Advanced ETL Processor Enterprise Download Visual Importer ETL Enterprise

We have 158 guests and no members online