SQL Import - Where is the existing record detection support?

[steveklett]

I rarely have projects involving SQL Server so maybe I'm missing something obvious, but I can't figure out how to UPSERT using IIO's automatic support for existing record detection.

This Help document doesn't match what I see in the UI:

The help article shows a Primary Keys field, but I don't have that.
I'm aware of the MERGE statement and that's what I'll use for a workaround, but would rather use Celigo's native support, if available.

Am I missing something?

[bhavikshah]

@steveklett If you're referring to bulk load (optimized) option then it is yet to be enabled on all the accounts. We intend to make this available soon for everyone. Meanwhile, if this is pretty urgent then we can enable this on your account sooner.

Optimized bulk load runs a COPY command from a single load ready file and handles the upserts by default.