Input: row set;
Output: validate the records using the other table’s data, and output the result.
Error Mesg: Error: 0xC020901E at Data Flow Task, Lookup 1 : Row yielded no match during lookup.
In SSIS 2005, if can not find the corresponding record, the component will be failed by default.
So the Error occurred.
// Proudly powered by Apache, PHP, MySQL, WordPress, Bootstrap, etc,.