Temporary tables with tMSSQLRow

Four Stars

Temporary tables with tMSSQLRow

Hi, 

What's the best way to create, update and delete temporary MSSql tables in Talend? 

I'm trying to use the tMSSqlRow component, but my result set is always blank. My queries do not throw any errors when running and takes approximately the same time to complete as it does directly in the database.  The tCreateTable component does not have the temporary table option for the MSSql database type.

I am using Talend v6.2

Thanks

Moderator

Re: Temporary tables with tMSSQLRow

Hello,

The tCreateTable has the function of creating a temp table in MS Sql Server .Becuase If table name starts with or # the table is assumed as a temp table.(MSSQL: CREATE TABLE ##AAA)

If you want to use a temp table, there must be t<DB>Connection component used in your workflow. The temp table would be destroied after connection closed.
Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download