Post reply

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

  • 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

  • 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.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • 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.

  • 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.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply