1) I am trying to get the value from a look up table into a @intial variable : example say "A" is need to be assigned to @intial
and since value "B" is added today recntly , this needs to go into varialble @max ='B'
look up TABLE:
7/22/2013 B ---@max
7/21/2013 A --@intial
2)After getting this value into variable , pass the value 'B' to the Stored Procedure " to run it once"
3) If there is one more value "C" is added to look up table tommorow then I need to pass
value 'B' to @intial varaible and value'C' to @max variable.
Now the Stored procedure needs to run twice , once for the value'B' and once for value'C' tommorrow.
7/23/2013 C ---@max
7/22/2013 B --@intial
On 7/24/2013 There is no new value added to lookup table , so the max value is 'C' , so stored procedure runs for only 'C' value passed.
How can I do this in SSIS?