Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks!!
I am newbie to the Talend and just started with a Data Integration tool.
I just exploring and got stuck at one point in context to connect two component which are doing different work but they are interdependent.
Scenario
- I have used component (say Com1) tMSSQL_1
- This calls a stored procedure and loading data into one SQL table <Table1>
- Second component (say Com2) used id loading data from above table <Table1> and inserting into other SQL table <Table2>)
- Now i have Com1 and Com2, and pre-requisite for Com2 is to execute Com1, but i am not able to provide this sequenece or not able to connect these two component sequentially in order Com1 ->Com2
Screenshot attached
Thanks
Amit Srivastava
fascinatingsql.blogspot.com
I don't see your screenshot, but I think these pages will help you out. For the MS Stored Proc look here: https://help.talend.com/reader/iYcvdknuprDzYycT3WRU8w/Y4ldtMoTiuC0d9L2HNRqzw
Connecting and working with MSSQL components: https://help.talend.com/reader/OwHoMAdhOJjvlcz1pzdCZg/8_1bcM8RufywgEwiAKsxAg
Hi @rhall
Actually i want to connect aformentioned component together, as source of the GenPassword table is stored procedure result set executed inside tMSSqlSP_1 component.
How to connect tMSSqlSP_1 and component containing (GenPassword and tMSSqlOutput_1)
Thanks
Amit Srivastava
https://fascinatingsql.blogspot.in
if you want to execute the GenPassword table after complition of tMSSqlSP_1 ,then Rigth click on tMSSqlSP_1>>Trigger>On Subjob Ok connect to GenPassword table.