Stop duplication data to be input in excel destination using SSIS 2015

• ericmbiada

  SSC Rookie

  Points: 47

  More actions

  September 28, 2017 at 5:10 am

  #333022

  Hello
  The package attached worked fine and all rows are inserted. what I am trying to do now is if a new data is added into the excel source and I run the package again only the new row is inserted into my excel destination. Thanks for your help

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  September 28, 2017 at 6:40 am

  #1961318

  One way of doing this would be to read the key data from the Excel spreadsheet into a cache transform as step 1 of your package and then use the generated cache as the source for a Conditional Split which checks incoming rows against those in the cache and discards matches.

  ---

• ericmbiada

  SSC Rookie

  Points: 47

  More actions

  September 28, 2017 at 8:09 am

  #1961356

  Phil Parkin - Thursday, September 28, 2017 6:40 AM

  One way of doing this would be to read the key data from the Excel spreadsheet into a cache transform as step 1 of your package and then use the generated cache as the source for a Conditional Split which checks incoming rows against those in the cache and discards matches.

  Thanks Phil for your reply I added the cache transform how can I specify the conditional Split.

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  September 28, 2017 at 8:38 am

  #1961366

  ericmbiada - Thursday, September 28, 2017 8:09 AM

  Phil Parkin - Thursday, September 28, 2017 6:40 AM

  One way of doing this would be to read the key data from the Excel spreadsheet into a cache transform as step 1 of your package and then use the generated cache as the source for a Conditional Split which checks incoming rows against those in the cache and discards matches.

  Thanks Phil for your reply I added the cache transform how can I specify the conditional Split.

  Read this for some additional info.

  ---