How to design SSIS Package for my below requirement please share some idea's and view to achieve this problem
1. We are having 2 different servers like (LNEW8T8,LNEW3T3) same databases and tables format we wanted to check the LNEW8T8 database and table (usertble).
If usertble table data if user id is exist don't want to insert the data in LNEW3T3 other wise insert the data.
please share more effective way of achieving this solution.