Post reply

ssis for not entering duplicate file

  • December 3, 2008 at 4:22 am

    #216035

    Hi all,

    I am new in SSIS and i have done one package for inserting data from txt file in database with foreach loop, but i am trying to do any condition if the file is entered in table database, of it is entered to not let to enter the same file name with that data.

    Thank's

  • December 3, 2008 at 4:28 am

    #906732

    What I would do is;

    Add a look-up transformation to look-up against the destination to see if the data exists, If you have a primary key you can join on this or you could join on the filename if you are saving it.

    Then I would add a conditional split that would split out the data returned from the look-up and dump all the records that have data as this would indicate that are already in the table. I would put these rejected records into a table or data file so you can check double check the logic.

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

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