I tried to create a global temp table in an SQL database to bypass limited database privs. Here is my FeatureWriter setting:
No 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!
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 ##MyTempTablethen 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!