Talend tMSSQLInput

Anonymous — Sat, 16 Nov 2024 07:46:48 GMT

I created a Talend MS Sql job using tMSQLInput_1 and inserted my own query. Below is example of my query.

if object_id('tempdb..#lang_guid')is not null
drop table #lang_guid;
create table #lang_guid(
patient_guid varchar(255)
,accountid varchar(255)
);
insert into #lang_guid

select c.customerid
,'0000001'
from customer c with(nolock)

select patient_guid
,accountid

from #lang_guid
The issue I'm having is the query pulls the patient_guid from the table but not the accountid I creating that on the fly in the temp table. when i run the job in Talend it returns the patient_guid but I don't get any data back for the accountid. Have anyone seen this issue with Talend before and if so how do I fix it.

Re: Talend tMSSQLInput

Anonymous — Fri, 24 Aug 2018 08:38:54 GMT

Hello,

Would you mind posting your job setting screenshots on forum which will be helpful for us to address your issue?

Best regards

Sabrina

Re: Talend tMSSQLInput

Jesperrekuh — Fri, 24 Aug 2018 11:26:56 GMT

Maybe make it a two step, first create and insert, next query.
And maybe COMMIT every 1 record?

topic Talend tMSSQLInput in Talend Studio

Talend tMSSQLInput

Re: Talend tMSSQLInput

Re: Talend tMSSQLInput