topic Re: sql temp tables in tmssqlinput in Talend Studio

sql temp tables in tmssqlinput

Anonymous — Wed, 14 Feb 2018 18:39:48 GMT

I am running a query on a mssql db. The query runs perfectly fine in microsoft sql server management studio. However, the query will not run in talend. I cannot share the code but below is the general flow of the code.

BEGIN

DECLARE A FEW VARIABLES

SELECT INTO TEMP TABLE1

SELECT INTO TEMP TABLE2

run queries

drop temp tables

Could someone please demonstrate the proper way to do this sort of query in talend?

Re: sql temp tables in tmssqlinput

vapukov — Wed, 14 Feb 2018 22:27:28 GMT

@Robert_gill wrote:

I am running a query on a mssql db. The query runs perfectly fine in microsoft sql server management studio. However, the query will not run in talend. I cannot share the code but below is the general flow of the code.

BEGIN

DECLARE A FEW VARIABLES

SELECT INTO TEMP TABLE1

SELECT INTO TEMP TABLE2

run queries

drop temp tables

Could someone please demonstrate the proper way to do this sort of query in talend?

"BEGIN
          DECLARE A FEW VARIABLES;
 
          SELECT INTO TEMP TABLE1;
          SELECT INTO TEMP TABLE2;
 
          run queries;
 
          drop temp tables ;

END"

Re: sql temp tables in tmssqlinput

Anonymous — Thu, 15 Feb 2018 01:53:31 GMT

That is how I had my code initially. If I use ";" talend throws syntax errors and if I don't use ";" the query begins to run then stops without displaying any sort of message.

Re: sql temp tables in tmssqlinput

vapukov — Thu, 15 Feb 2018 02:02:15 GMT

look,

I can try to guess - what are do wrong ... but do I need this?

what I know, my code - is work

I have my own code - it work

I create code similar to describe in Your pseudo code - it work

why all must guess - what also You are forget include 🙂

Code:

Result:

Re: sql temp tables in tmssqlinput

Anonymous — Thu, 15 Feb 2018 02:04:55 GMT

It is weird, the query results do not appear when i test the query.
However, talend can guess the schema and pull the data

Re: sql temp tables in tmssqlinput

vapukov — Thu, 15 Feb 2018 02:13:52 GMT

tSQLRow - do not proper component for return result (even in combination with)
Use tMSSQLInput instead