Strange Behavior

i have 2 packages ease i'll call parent & child.  parent package calls child package 4th step in process.  once child has completed, parent has few more imports does.

 

the portfolio table loaded in child package step 4 in parent package.  in step 5 few tasks utilize portfolio data lookups. 

 

the strange part there 4 or 5 data tasks lookups against portfolio data in step 5 (step 5 container).  2 of data tasks retreive data portfolio data.  other 2 don't find data , move on.  once package stops, if execute tasks run , load data correctly.

 

it seems me caching or isolation problem can't find solution.

 

any ideas?

are of lookups using same select statement populate reference table? if so, might try changing each of them unique - can add comment query force uniqueness.

 

lookups internal caching, , we've encountered issues in past cache gets flushed little early. there's kb article on somewhere, can't track down right now.

SQL Server  >  SQL Server Integration Services