ssis doubt

• asranantha

  SSCarpal Tunnel

  Points: 4246

  More actions

  November 17, 2011 at 2:10 am

  #252091

  hi friend,

  suppose i ahve one destination table withe some data suddenly 2 excel files data wantt to insert into the destination table but how to know this data is already inserted into the destination and only new data is insesrted into the destination.

  plese tell me the process in ssis packages

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  November 17, 2011 at 2:26 am

  #1409031

  Here you go:

  http://sqlblog.com/blogs/andy_leonard/archive/2011/11/10/1631.aspx

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• Tej Bahadur Singh

  Newbie

  Points: 1

  More actions

  November 21, 2011 at 11:10 pm

  #1411202

  You can use lookup transformation and on certain column you can check if the data is already exists.