I'm having troubles exporting the contents of a global temporary table into an excel via the "automation script" option.
So far I've read that it is necessary to have the tick option in the "connection manager" ticked and the connection upon start.
I also preserve the rows after commit, however I still get the error message that my temporary table does not exist.
Is there anything I am missing?
Thanks so much for any help!