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