Talend tMSSQLInput

Five Stars

Talend tMSSQLInput

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.

Tags (2)
Forteen Stars

Re: Talend tMSSQLInput

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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Forteen Stars

Re: Talend tMSSQLInput

@masonjames,did it help you?

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

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