There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
MERGE Destination fails to create TVP
The MERGE Destination failed during the create TVP step when the source/target contains an nvarchar(max) column.
Incorrect syntax near ')'.
Sample TVP create:
create type TVPType8b78e67fe4e746c4993ff76d8496e31b as Table(
Note -1 was passed to SQL Server instead of max for the largetext column.