Passing run time variables to ODBC stage
Posted: Thu Feb 11, 2010 6:13 am
Friends,
Is there a way to pass variables during the run time to the ODBC stage?
My current project requires me
1) To get a value from the log table and pass this to the next stage (ODBC.)
2) Use the above value in the WHERE clause of the 2nd ODBC stage to retrieve data from the source
1st ODBC(get the value from log table) ==>2nd ODBC (use the value and retrieve data from source)
Thanks in advance
Yamini
Is there a way to pass variables during the run time to the ODBC stage?
My current project requires me
1) To get a value from the log table and pass this to the next stage (ODBC.)
2) Use the above value in the WHERE clause of the 2nd ODBC stage to retrieve data from the source
1st ODBC(get the value from log table) ==>2nd ODBC (use the value and retrieve data from source)
Thanks in advance
Yamini