Forum Discussion
QUESTION::COPY DATA::UPSERT FAIL
The source is an on-prem SQL Server, and the destination is a lakehouse table. I use a Copy data activity pointing to the lakehouse SQL endpoint in order to get access to the Upsert option.
Ca...
Hi Element115 ,
Based on the information you have provided, you are experiencing an error message displayed:
Global temporary tables and transient user tables in TEMPDB are not supported in this edition of SQL Server.
You can follow the steps below to test and troubleshoot the problem:
- First you need to verify the version of SQL Server you are using, as some versions may have limitations on certain features.
- If the query is using global temporary tables, consider modifying it to instead use local temporary tables (prefixed with #), which are supported by all versions of SQL Server.
If there is still a problem, could you please provide some information such as what you did before the error occurred and has the problem occurred before?
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ticket #2407230040010740