Four Stars

Temporary tables with tMSSQLRow


What's the best way to create, update and delete temporary MSSql tables in Talend? 

I'm trying to use the tMSSqlRow component, but my result set is always blank. My queries do not throw any errors when running and takes approximately the same time to complete as it does directly in the database.  The tCreateTable component does not have the temporary table option for the MSSql database type.

I am using Talend v6.2