This example demonstrates how to create a mail merge workflow package.
Data example
The solution
Transformation is loading emails into the database
How it works
- A list of emails is loaded from the database.
- Loop over the list,
- Assign the variables
- Send emails.
- Reset variables back to the original
To view the example follow the steps below
- Download and install Advanced ETL Processor [Link]
- Download and Unzip example[Link]
- Create a new SQL server connection if necessary
- Create EMAILs table (0024 Create Table.sql)
- Create a new transformation and open .ats file
- Double-click on the Reader object and amend the source file path
- Double-click on the Writer object and select the connection created in step 2
- Select the table created in step 4
- Save the transformation
- Create a new SMTP connection if necessary
- Create a new SQL script (0024 Get Variables.sql)
- Create a new SQL script (0024 Loop Script.sql)
- Create a new workflow and open .wfp file
- Double-click on the transformation and select the connection created in step 5
- Double-click on the loop and select the SQL script created at step 12
- Double-click on the set variables and select the SQL script created in step 11
- Double-click on the Send Emails and modify email text if necessary
- Press the green arrow to run the transformation
Please contact us if you need help with transforming the data
Visit ETL Tools Forum |