Setting Variable from row in csv file

What approach should I use to put the excel file into the database you reference?

yes please send a working example. the source csv file updates weekly

Here is a basic tutorial

www.etl-tools.com/advanced-etl-processor...-mysql-database.html

In MSSQL writer how do you select the update key?

Wiki has all the answers

/wiki/advanced-etl-processor/transforming-data/writer-targets/updatedelete-records/

Mike,

I do apologize. I am stuck in the same spot I was when I started. I have an MSSQL table loaded to mirror the excel file data. I am still missing specifically how to load the table data field into the Set Variable. I have been through the wiki and videos multiple times. I am just not understanding what I am missing. is it a SQL script? if so I still do not understand how the data gets to the variable. al my attempts have failed. this is three days on what should be a simple mailmerge workflow.