SSIS MySQL Lookup - UPDATE or INSERT?

[tarasverq1]

Hello!

I'm trying to use yours MySQL Lookup component trial.

I have one simple question.

How can i separate records which I need to update from records to insert in "Lookup No Match Output"?

I have no output columns such as ID at "Lookup No Match Output".


Thanks for your help!

[Shalex]

A standard Lookup behaves in the same way. There is no additional lookup column in the No Match output.

Did you try to assign Lookup Error Output (of Devart MySql Lookup) to Devart MySql Destination? All available input columns (without additional lookup column) should be passed to the destination. Be aware about the NoMatchAsError property (to redirect no matching rows to error output) via Advanced Editor for Devart MySql Lookup.