How to reject if duplicate records are there in flat file data by checking table data in SSIS 2008 R2?
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.
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance