Use Sql Server temp table created in sub job

[smunagala1615566132]

Hi ,

I'm calling child job from parent job using tRunJob component. I'm connecting to the same sql server in both the jobs.

Creating a temp table in child job and trying to use the same in parent job . Tried various combinations but nothing works out.

Could any one please help.

[Anonymous]

Hello,

If we understand your requirement very well, you need to use a file to pass values from child job to parent when running as an independent process.

Here is a KB article about: https://community.talend.com/s/article/Returning-a-value-from-a-child-Job-to-the-parent-Job-DqbEu

Let us know if it is what you are looking for.

Best regards

Sabrina