July 22, 2013 at 9:51 am
SSIS Package:
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-2 ='B'
look up TABLE:
DATE flag
7/22/2013B ---@max
7/21/2013A --@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-2 variable.
Now the Stored procedure needs to run twice , once for the value'B' and once for value'C' tommorrow.
DATE flag
7/23/2013C ---@max
7/22/2013B --@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?
Thanks,
Komal
July 23, 2013 at 1:24 am
I see no reason to do this in SSIS.
SSIS will not "remember" the values you stored in the variables. It only maintains the values of variables during runtime. You'd still have to persist the values in a table.
I would implement your logic in TSQL, probably will be a lot easier.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply