August 4, 2008 at 4:15 pm
hello every one.
I need some help. I am using SSIS to transfer data from oracle to sql. For the different purposes i use temp tables as a lookup for references and it work fine. Today i was using temp table as lookup and i use source and connect it to the lookup to retrive the value and it works fine.
Then i made another source and created another lookup and use the same table for reference and to retrive the same val as i use in the previous source. But the source table is different. But it is not retrieving anything and gives me error'
No rows yeild during lookup
can anybody tell me what is going on here?
thanks
August 4, 2008 at 4:23 pm
If you mean temp table's as in # or ##. # can only be accessed in the same session. ## can be accessed from other sessions.
August 4, 2008 at 7:35 pm
its ##
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply