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


  • Hi ,

    i got one requirement like


    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.


    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.


    Saturday, July 13, 2013 6:28 AM


All replies