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