How to join table columns and view columns, store in postgres and to perform incremental load in ssis package.

See more:

SSIS

I have a table columns A,B,C,D,E,F and view columns F,X,Y,Z . Both Table and View columns from SQL Only. The result A,B,C,D,E,F,X,Y,Z has to store in PostgreSQL Table. F is a common column contains string values but not primary key. Table contains some 6000 records and from view 4500 records. The result table should contain 10500 records and whenever new records are inserted in table or view, only the new records have to store in PostgreSQL table. No updates only new records have to insert into postgresql. This has to achieve using SSIS package.

What I have tried:

1. Taken OLEDB source, given connection for the view
2. Taken LOOKUP, configured with SQL table columns, mapped F column from view to F from table. selected all columns from lookup columns(table). Lookup no match output to ODBC Destination.
3. ODBC destination (PostgreSQL), in mapping I couldn't see columns of table in input columns to match. view columns mapped from input columns to Destination column.
only the records from view are inserting in PostgreSQL.
Please suggest me how to achieve this.