Pass variables between jobs

[shyam_etl]

Hi all,


I have a scenario, where I have a table with one of those columns, which gives me the 'SQL ( select stagement which is expected to return four columns ) stament'.

Is there a way I can assign this string ( SQL statement ) value to some variable and then use the same in an ODBC stage ( In the User Defined Query).

Is there any approach that would let me pick the String value and use it in an ODBC SQL tab?

Cheers,
Shyam

[kduke]

The problem is the metadata. I do this all the time. Part of EtlStats has jobs like this. You have to use a parameter. When I reseed the SDKsequences then I use:

select max(#ColName#) from #TableName#

The SQL in one job is:

#SqlStmt#