Getting Last Generated SK from Surrogate Key Stage
Posted: Wed Oct 13, 2004 10:58 pm
Hi all,
I'd like to know what's the best way to get last generated SK for the SK stage. This will be used as the "Start Value" property of the SK stage.
I searched through the fourm, and found someone is doing a SQL query
over the table, and get the max. value of the S.K. and then get this value
back to DS through DSExecute & DSSetParam.
Is it a good way? Any other better ones?
Thanks very much.
I'd like to know what's the best way to get last generated SK for the SK stage. This will be used as the "Start Value" property of the SK stage.
I searched through the fourm, and found someone is doing a SQL query
over the table, and get the max. value of the S.K. and then get this value
back to DS through DSExecute & DSSetParam.
Is it a good way? Any other better ones?
Thanks very much.