DSXchange

Thanks for your help

Just wondering whether UPSERT mode works for only inserts?

Thanks

Sure, but the question is in what order are the operations performed? Either way will work as desired - provided the updates are filtered out - but best to perform the insert attempt first so that you don't burn two database operations for every record. I don't have any kind of access right now, do you have control over if it does "insert else update" versus "update else insert"?

Thanks

Well these are the options

If we mention Write method as UPSERT then i can see options under Upsert Order (Insert then Update) and (Update then Insert). According to what I understood is as i am filtering out Updates in can use Insert then update as Upsert order. Am i Right?

Thanks

As noted, either will work but "Insert then Update" would be the smarter choice.

Thanks

But under Upsert mode i can see 4 options

Autogenerated Update & Insert
Autogenerated Update only
user defined Update& Insert
user defined Update only

can i go for First option?

Thanks

yes you can go for that...unless you want to mention INSERT/UPDATE statements manually.

Since for whatever reason you don't seem to have "Insert then Update" as an option, then yes - go manual and include only the insert dml.