Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Data flow stops in lookup
Tried the error output. There are no error output. All the data in the source exists in the lookup tables. It as if the package is running out of steam as soon as the lookups are hit. I've also tried all the Cache modes, but the result remain the same. At the peak during package execution the...- rflouw
- Post #3
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
Data flow stops in lookup
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...- rflouw
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Integration Services (SSIS)
