October 3, 2011 at 10:48 pm
I am having table like this
sale_id,prod_id,qty
1,10,100
2,20,300
3,30,200
i want to keep the last sale_id(3) into one variable by using ssis package how to do this...
if i insert any new row into my sales table
ie,
4,20,300
5,40,300
6,30,400
then d last sale_id(6) automatically update into that variable
October 4, 2011 at 3:32 am
Each time you restart the SSIS package, the variable value will be reset. So I would store something like that in the database.
(Or just retrieve it from the table itself with a simple SELECT MAX() query)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 4, 2011 at 3:50 am
how to pass table value to variable in ssis
October 4, 2011 at 3:52 am
Anand.A (10/4/2011)
how to pass table value to variable in ssis
Here you go:
http://msdn.microsoft.com/en-us/library/ms141689.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply