Member since
11-30-2016
2
Posts
0
Kudos Received
0
Solutions
12-01-2016
06:02 AM
Thanks Peter 🙂 I will probably go with the ExecuteProcess processor to invoke a script to invoke the SQL Server MERGE command
... View more
11-30-2016
05:44 AM
I am using MS SQL Server as my data store. The PutSQL processor is great if we are clear about the kind of DB operation we want to perform ie. INSERT or UPDATE. But what if we want to do something like UPSERT or MERGE operation? eg. https://myadventuresincoding.wordpress.com/2016/01/05/sql-server-how-to-write-an-upsert-using-merge/ I can't find any suitable set of processors that can achieve this. Anyone done this before?
... View more
Labels:
- Labels:
-
Apache NiFi