Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Let me explain the complex problem.
1. In my main job I am reading the data from a Oracle table and extracting EMPLOYEE_ID as numeric values.
2. So In my subjob I have a SQL Server tMSSqlInput component to select the data. where my sql look like this:
Select name,employee_id
from emplyees
where employee_id In(.............................................)
I can't use a join between the two database.
So if I want to put/store the values of the 1st SQL component output in a variable and call it inside the 2nd subjob SQL how i can do it.
So now I want to use the output value of the 1st job inside the where clause of the 2nd job's sql