InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 04:24:32 GMT20http://www.sqlservercentral.com/Forums/Topic1360532-148-1.aspx[quote][b]ranganathanmca (9/17/2012)[/b][hr]Hi Guys,How to design SSIS Package for my below requirement please share some idea's and view to achieve this problem1. 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.ThanksRanganathan palanisamy[/quote]Few queries here.1. Why only SSIS ? You could have used linked server concept also.2. What is the source of Userid i.e. are you checking with some file or again from some other database.Mon, 17 Sep 2012 22:37:02 GMTrhythmkhttp://www.sqlservercentral.com/Forums/Topic1360532-148-1.aspxHi Guys,How to design SSIS Package for my below requirement please share some idea's and view to achieve this problem1. 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.ThanksRanganathan palanisamyMon, 17 Sep 2012 20:35:41 GMTranganathanmca