HOW TO CREATE A TEMPORARY TABLE MS SQL Server

[Anonymous]

Hello,
how to proceed to create a MSSQL temporary table from Talend,
when i use tMSSQLoutput or tcreateTable, there is not way to specify that a temporary table, I tried to choose "#tmp" as the table name, but i receive an exception.
please can some body help me.
THX A LOT

[Anonymous]

Hello
On tCreateTable, there is a option 'Temporary table' option, check this option.
What's your problem?
Best regards

shong

[Anonymous]

When you choose MS SQ Server I have not this option, bu when I choose an another Db like MySQl I can SEE this option .
Thx

[Anonymous]

Hello

When you choose MS SQ Server I have not this option

Yes, you are right. This feature is missing on MS SQL Server. Would you like to report it on our bugtracker?
Best regards

shong

[c0utta]

Hi talender,
Although this is true, you can use a tMSSQLConnection component and then create the temporary table and then read the contents back with a tMSSQLInput using the same connection. Since you're using the same connection (and therefore the same session) you can read the temporary table back.
Cheers,
c0utta

[Anonymous]

Hello Experts,
I am mapping fields in Oracle database to MS SQL database using tMap component. I think that the mapping details like which fields in Oracle is being mapped to MS SQL field is stored in some xml or flat file format. Could you please tell me where is such information stored? Where can I retrieve it from?? Please help. Many thanks!
-Sonal.

[c0utta]

sonal,
Please don't hijack threads as they will most probably go unanswered. Create a new thread because your question has nothing to do with temporary tables in MSSQL.
Read http://www.talendforge.org/forum/misc.php?action=rules for forum etiquette.
c0utta

[Anonymous]

Hi c0utta,
Yes I am allways using tMSSQLConnection, but can not process temporary #table .
I am looking for another issues
Thx lot

[Anonymous]

Hi All
I report a new 7675 on this issue.
Thanks for your support!!
Best regards

shong