I am trying to load a .xlsx file from the ifs and then read through it a row at a time using a rowset and a For-Each Loop. Within the loop I am inserting the row into a database file. The database file has a sequence number in it and I was trying to use an index from the For-Each Loop for the sequence number. It is crashing after the first insert, giving me a duplicate key error. The duplicated is caused by the sequence number not incrementing. Is there a sample program that I can look at to figure out what I am doing wrong?

Please post a copy of your Project XML and the associated JobLog (in debug mode) so that we can see what you're trying to accomplish.

Patti,

Look at removing the ${Row} from the "Insert Rowset Variable" inside of the For-Each loop on the Insert of your data. You're telling the project to insert every row from the rowset each time through, thus .. the 2nd time through you are trying to insert the same data again, giving you duplicates.

Once inside the For-Each loop, you're controlling the insert of each record, so, the input rowset variable isn't needed in this case.

Hope this helps!