Hi, I am using "Cache Transform" in my SSIS Package to prevent duplicate records to insert in sql table from excel search by Name. can you help me that how to set "Cache Transform" for this

Not sure how you want to use it, but you can fill the cache within a data flow with the Cache TransformPlease mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Dont go for complex methods.. Keep it simple.. Use SCD ,if u have small volume of data or you can go lookup which has inbuilt cache functionality.. use full cache mode in lookup..

there are better methods for removing duplicate records other than using cache transform. here you can find a brief article about removing duplicates with SSIS: http://toddmcdermid.blogspot.co.nz/2009/01/eliminating-duplicate-primary-keys-in.htmlhttp://www.rad.pasfu.com

Hi AshishSingh_DWH, The Cache Transform transformation writes data from a connected data source in the data flow to a Cache connection manager. If you only need to prevent duplicate records to insert in sql table, please refer to Reza's suggestion. If you curious about Cache Transform, please refer to: http://msdn.microsoft.com/en-us/library/bb895264.aspx Please feel free to ask if you have any question. Thanks, EileenPlease remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.