Question

Problem creating MSSQL global temp table using FeatureWriter

  • 21 May 2023
  • 1 reply
  • 0 views

Badge +2

I tried to create a global temp table in an SQL database to bypass limited database privs. Here is my FeatureWriter setting:

imageNo errors were given, but the temp table was not created on the SQL server tempdb. I tried using the fully qualified name tempdb.dbo.##MyTempTable for example to no avail. Appreciate any suggestions!

 


1 reply

Userlevel 1
Badge +14

Hi @Bo Guo​ I am not well versed in this topic, but you can probably use the SQLExecutor, first to create the table with 

create table ##MyTempTable

then add the record. As seen in this thread for more information

 

You might also need to create the temp table before writing to it. e.g. using the SQLExecutor to CREATE the table, then FeatureWriter to load the records. Hope this helps!

Reply