How to select not exists data in SSIS package

Posted on

Question :

i dived into SSIS because of curiosity, what i want to do is inserting “Not Exists” Data to postgresql. i want to select “Not Exists” data from Postgresql which is joined to the data selected from Mssql, and insert into Postgresql. Below is the Data Flow Task.

Sorry for my English, i hope you got i what i want to do.

enter image description here

Answer :

i achieved by following this post;
How to get unmatched data between two sources in SSIS Data Flow?

and here is my screen shot;

enter image description here

by doing this, i am joining 2 different sources and splitting unmatched data than i insert into destination.

i appreciate your efforts. Thank you so much.

Leave a Reply

Your email address will not be published. Required fields are marked *