Database Stream In - Schema Selection

[cyoung3]

I am trying to stream a text output into the database as a temporary table, but it is automatically attempting to create the temporary table in the public schema (as opposed to the schema I have access to create temp tables in). Is there any way to specify the schema to create the temp table in? 

p.s. all of my in-db connections are working in all other areas and I am able to specify the schema in my queries. 

[patrick_mcauliffe]

@cyoung3  you should be able to specify the default schema in your database connection (assuming ODBC).  That would change where the temp table is written.