topic Re: HOW TO CREATE A TEMPORARY TABLE MS SQL Server in Talend Studio

HOW TO CREATE A TEMPORARY TABLE MS SQL Server

Anonymous — Sat, 16 Nov 2024 13:55:58 GMT

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

Re: HOW TO CREATE A TEMPORARY TABLE MS SQL Server

Anonymous — Wed, 03 Jun 2009 10:21:53 GMT

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

shong

Re: HOW TO CREATE A TEMPORARY TABLE MS SQL Server

Anonymous — Wed, 03 Jun 2009 10:25:03 GMT

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

Re: HOW TO CREATE A TEMPORARY TABLE MS SQL Server

Anonymous — Wed, 03 Jun 2009 11:15:07 GMT

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

Re: HOW TO CREATE A TEMPORARY TABLE MS SQL Server

c0utta — Thu, 04 Jun 2009 05:00:38 GMT

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

Re: HOW TO CREATE A TEMPORARY TABLE MS SQL Server

Anonymous — Thu, 04 Jun 2009 13:44:37 GMT

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.

Re: HOW TO CREATE A TEMPORARY TABLE MS SQL Server

c0utta — Fri, 05 Jun 2009 03:13:38 GMT

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

Re: HOW TO CREATE A TEMPORARY TABLE MS SQL Server

Anonymous — Fri, 05 Jun 2009 10:05:52 GMT

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

Re: HOW TO CREATE A TEMPORARY TABLE MS SQL Server

Anonymous — Tue, 09 Jun 2009 07:58:00 GMT

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

shong