topic Connecting tMSSqlRow to tMSSqlInput in Talend 5.3.1 in Talend Studio

Connecting tMSSqlRow to tMSSqlInput in Talend 5.3.1

Anonymous — Thu, 23 Oct 2014 22:57:00 GMT

I have a Talend job where tMSSqlRow executes a number of SQL queries and creates a temp table at the end. It is connected to a tMSSqlInput, where the data is selected from that temp table and the schema of tMSSqlInput matches the temp table structure. Then tMSSqlInput is connected to a tMap control. This job was created in an earlier version of Talend. I need to make modifications to this job. When I tried to add new components and mimic the same design, I realized that I cannot connect components in the same way. I can connect tMSSqlRow to tMSSqlInput, but then I cannot connect tMSSqlInput to tMap. If I connect tMSSqlInput to tMap first, then I cannot connect tMSSqlRow to tMSSqlInput. Even if I delete existing OnSubjobOK connection from a job that was developed earlier, I cannot add it back (luckily Ctrl Z brings it back). Is that functionality no longer supported in 5.3.1? Am I doing something wrong? I tried to attach a picture, but got an error message...
Thank you for your help,
Mikhail.

Re: Connecting tMSSqlRow to tMSSqlInput in Talend 5.3.1

Anonymous — Fri, 24 Oct 2014 04:23:10 GMT

Hi,
Please upload your current job design screenshots into forum so that we can get your situation more precisely.
Best regards
Sabrina

Re: Connecting tMSSqlRow to tMSSqlInput in Talend 5.3.1

Anonymous — Fri, 24 Oct 2014 15:34:48 GMT

This is a fragment of the existing job. What I am trying to recreate is circled - a connection between tMSSqlRow and tMSSqlInput, and tehn to tMap. (Hopefully the image is going to be uploaded correctly this time...)
Thank you very much for your help,
Mikhail.

Re: Connecting tMSSqlRow to tMSSqlInput in Talend 5.3.1

Anonymous — Fri, 24 Oct 2014 16:52:11 GMT

Another curious fact - I can do it in a brand new job. Is it possible that something happened during upgrades from one version to another? All jobs have been upgraded to higher Talend versions at least twice.