SSIS MySQL Lookup - UPDATE or INSERT?

SSIS MySQL Lookup - UPDATE or INSERT?

Postby tarasverq1 » Fri 08 Sep 2017 15:13

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".
Image

Thanks for your help!
tarasverq1
 
Posts: 2
Joined: Fri 08 Sep 2017 15:11

Re: SSIS MySQL Lookup - UPDATE or INSERT?

Postby Shalex » Mon 11 Sep 2017 17:01

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.
Shalex
Devart Team
 
Posts: 7780
Joined: Thu 14 Aug 2008 12:44


Return to SSIS Data Flow Components