I have several lookups but the data flow stops at the fifth lookup without utilizing all the upstream data. This is a fairly basic flat file to database insert package in SSIS 2008. The lookup nodes lookup the corresponding surrogate keys before data is inserted into a fact like table.
I‘ve...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.