Inserting context of the file inside email message text

Here is very basic example of email automation

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

Automation Package

Variables

Send Email Action

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

• Using script action
• Using transformation action
• Using calculation object within transformation action or package
• Using “Variable Actions”
• Manually using Global Variables

Variables Actions

1. Load Variable Action
2. Delete Variable Action
3. Select Value Action
4. Set Variables Action
5. File to Variables Action
6. File Line to Variables Action
7. SQL Record to Variables Action
8. SQL to Variables Action
9. Command Line Parameters Action

Video Tutorial