none
How to reject if duplicate records are there in flat file data by checking table data in SSIS 2008 R2?

    Question

  • Hi ,

    i got one requirement like

    Steps

    1. Client will sent one fixed length file on daily basis , we have to load the data into one staging table 

    2. then i am running one distributed procedure to distribute the data

    3. after that i am moving the file to archive folder.

    Note: Up to above points i succeeded.

    Requirement:

    1. Now while loading new file i have to verify like  if any record existed  in a table then that record need to be reject and then i have to load the data.

    how do i verify whether record existed or not in a table by comparing flatfile fixed length data to the table data.


    franklinsentil

    Saturday, July 13, 2013 6:28 AM

Answers

All replies