Hi, i need to compare many columns in a lookup.due to performance issues i would like to generate a hash key based on these columns in DB level.and compare the hash keys and update /insert the rows based on it. could you please advice or guide for any material on this. Thanks

Here is some info from the forum that might be helpfull: http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/4215ab96-18fd-4a4f-a022-f6469ba70373Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

Have a look at this custom component: Multiple Hash - SSIS Multiple Hash makes it possible to generate many Hash values from each input row. Hash's supported include MD5 and SHA1.My Blog | Ask Me

Have a look at this custom component: Multiple Hash - SSIS Multiple Hash makes it possible to generate many Hash values from each input row. Hash's supported include MD5 and SHA1.My Blog | Ask Me