can we use update else insert statement in apply statement of tpt script which is using update operator . i am planning to use case condition ,based on that i want to do update else insert in 3 target tables.The data is getting from one source file.
please let me know the syntax if its possible to use?
The APPLY clause (for each target table) should have one UPDATE statement followed by one INSERT statement and the INSERT FOR MISSING UPDATE ROWS modifier.
See the TPT User Guide and the PTS00004 example (in the sample directory where TPT is installed).