07-30-2009, 02:56 AM
Hi,
I'm hoping someone can help me. I'm wondering if it is possible to use an output value that I have stored in my test run and use it as input in a SQL statement (Database checkpoint). The output value is a parameter so it can change from run to run, hence my reason to be able to use the run's output value in the SQL query. Is there a way to do this? I have tested my connection but need to drill down and figure out how to word the query.
Any input would be appreciated! Thank you.
I'm hoping someone can help me. I'm wondering if it is possible to use an output value that I have stored in my test run and use it as input in a SQL statement (Database checkpoint). The output value is a parameter so it can change from run to run, hence my reason to be able to use the run's output value in the SQL query. Is there a way to do this? I have tested my connection but need to drill down and figure out how to word the query.
Any input would be appreciated! Thank you.