DUPLICATES IN A SSIS PACKAGE

  • Hi,

      i need help on this.

     

    i created a package in SSIS with an excel source and OLEDB DESTINATION.it runs fine THE first time but when i run it again it gets duplicates RECORDS.

    Any suggestions

  • you might have to check the workflow properties to empty the table at the destination if you wish to or change the workflow to use SQL Query where you can retrieve only records that have not been updated before

Viewing 2 posts - 1 through 2 (of 2 total)

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