Hi, I have a ssis package with several lookups. I want that when a row is not matched the package fails and the row is reedirected no error output. With this I can do a insert in a table to store the rows that are not matched. But in the Lookup it only is possible to Failt or to send to error output. I want to do the 2 things. Best Regards

When you redirect you can insert the rows to a table. And then fail the package with a Script Task: Dts.TaskResult = Dts.Results.Failure Arthur My Blog