Click here to Skip to main content
15,664,435 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900