greengiant
SSC Eights!
Points: 961
More actions
September 4, 2009 at 9:43 am
#225848
I have a OLE DB Source where I do a
Select X
From Tbl1
where Y = (?)
I want to pass the value for (?) from a Exec Sql that gets the value for Y. I want the value P to be fed into Y. How do I do this.
SELECTP
FROM Tbl2
J Livingston SQL
SSC Guru
Points: 51550
September 5, 2009 at 11:01 am
#1049766
Hi the following link may help:
http://sqlfool.com/2009/08/getting-started-with-variables-in-ssis/
________________________________________________________________you can lead a user to data....but you cannot make them think and remember....every day is a school day
September 8, 2009 at 7:44 am
#1050508
Thank you. This is very helpful.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply