One Star

HOW TO CREATE A TEMPORARY TABLE MS SQL Server

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
8 REPLIES
Community Manager

Re: HOW TO CREATE A TEMPORARY TABLE MS SQL Server

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

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: HOW TO CREATE A TEMPORARY TABLE MS SQL Server

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
Community Manager

Re: HOW TO CREATE A TEMPORARY TABLE MS SQL Server

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: HOW TO CREATE A TEMPORARY TABLE MS SQL Server

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
One Star

Re: HOW TO CREATE A TEMPORARY TABLE MS SQL Server

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.
One Star

Re: HOW TO CREATE A TEMPORARY TABLE MS SQL Server

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
One Star

Re: HOW TO CREATE A TEMPORARY TABLE MS SQL Server

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

Re: HOW TO CREATE A TEMPORARY TABLE MS SQL Server

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

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business