Friday, March 30, 2012

Fix Lookup Error in SSIS

when i test my SSIS package that will extract Data from an excel spreadsheet and import them into a sql server. i got an annoying error when i execute the package.

"Error: 0xC020901E at Extract TCCI excel data, Lookup My Look Task [5281]: Row yielded no match during lookup."

this error is stem from the error handling configuration. by default, it is set to FAIL COMPONENT, this setting will cause the package to crash after the LookUp process is failed.




after i changed it to be IGNORE FAIL then my package successfully import the data into SQL Server.



No comments:

Post a Comment