Talend tMSSQLInput

Anonymous — Sat, 16 Nov 2024 08:18:11 GMT

I created a Talend MS Sql job using tMSQLInput_1 and inserted my own query. Below is an 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 accounted 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 account. Have anyone seen this issue with Talend before and if so how do I fix it.

Re: Talend tMSSQLInput

manodwhb — Mon, 07 May 2018 10:11:22 GMT

@masonjames,in tMSSQLInput_1,you can use only the select query to extract data from MS SQL DB.

Re: Talend tMSSQLInput

manodwhb — Tue, 22 May 2018 08:40:40 GMT

@masonjames,did it help you?

topic Re: Talend tMSSQLInput in Talend Studio

Talend tMSSQLInput

Re: Talend tMSSQLInput

Re: Talend tMSSQLInput