how to assign tMSSqlRow value to context variable ?
Below is my query is written in tMSSqlRow_2. Need to read the value from tMSSqlRow_2 and assign to context variable. how to achieve this? Please help
select @srcid=srcid from dbo.src_tbl where src_name='xxx';
select sessionid from session_tbl where srcid=@srcid and loaddate='2011-12-20'
sessionid int IDENTITY(-3333333,1) not null ,
Name Type Value (default)
SessionID Int -9999999
i have followed this :
tMSSqlConnection -->tMSSqlRow_1 --OnComponentOK---> tMSSqlRow_2 ---main--->tJavaRow-->tLogRow
i have written above code in tMSSqlRow_2, in tMSSqlRow_1 ("sessionid") is getting populated.
When i run job it is writtening null.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Introduction to Talend Open Studio for Data Integration.