Sql-server – How to select not exists data in SSIS package

postgresqlsql serverssis

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

Best 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.

Related Question