How to resolve SSIS “Row yielded no match during lookup” error.
January 26th, 2022 in Blog, Business Intelligence, SSISHave you ever been faced with the SSIS error “Row yielded no match during lookup”? If so, this blog is for you! A customer of ours recently faced the same issue in one of their SSIS packages and asked us to investigate this for them. Initial investigations on their side highlighted that when they replicated the lookup component using a standard join in T-SQL (similar to the image below) it returned the expected results. So why was SSIS…
» Read more