Forum Discussion

bubba's avatar
bubba
New Contributor
4 years ago

Questions on using the SQL Server – Merge snap, where is WHEN MATCHED logic?

Hello, I’m a new user to Snaplogic, so go easy. 🙂 My question is on using the “SQL Server – Merge” snap: I’ve created a pipeline to import from a sftp csv-formatted source to merge (update or in...
pipeline
sqlserver
Matthias's avatar
Matthias
New Contributor III
4 years ago
Copy Link
  1. your screenshot suggests that you forgot to tick the “evaluate as expression” - so the content (ID = $['xxxx']) will be evaluated as string - ignoring the reference to the input document.
  2. Identity column is usually the ID column - the one that’s autogenerated, and in most cases i’ve encountered with SQL Server, a UUID within the database.
  3. you should look at what is placed next (on top of) the sql server merge snap. This error usually appears if there’s no room for the (new) output or input view on the canvas. You can unsnap it from all other elements and move it to a free space in your canvas, which should allow you to add an error view (you’ll then obviously have to find a room where it’ll fit in).
  • bubba's avatar
    bubba
    New Contributor
    4 years ago
    Copy Link

    Much thanks for your feedback. I’m still testing but it’s now working as expected as far as I can see.