Insert step inserts records into database table twice

Help
1

Created a data table and tried to insert records into database table using “Insert” activity. It reports records affected as the correct number but inserts twice the number of records in database table (duplicates)

2

Hi @R.J_Narayanan
Is insert statement used twice or manually inserted

Thanks
Ashwin.S

3

It is used only once as activity and gets executed only once. It is not in any loop.

Thanks and regards

RJ Narayanan

EDEF450273364AD99915064591597876.png
EDEF450273364AD99915064591597876.png708×1 83 Bytes

1 Like
4

can you send the screen shot of your workflow or can you upload the XAML

5

image
image741×619 14.8 KB

Insert activity is inside the try catch activitiy

6
  1. try block has only insert activity or has other activity?
  2. what did you include in catch block same query again?

this is just a suggestion: Execute query will return you the data table which directly you can use to write the excel file hope in build data table you are not pushing the out put of the EXECUTE query.

7

Try catch block has one insert activity and nothing else. Catch just catches system exception and does nothing (empty)