tag:blogger.com,1999:blog-5472436831307966815.post8747899985425756609..comments2024-03-20T00:30:07.883-06:00Comments on Daniel Cai's Blog: SSIS and CRM Series, Part 4 - Use SSIS to Implement Data Quality Solution for Microsoft Dynamics CRMDaniel Caihttp://www.blogger.com/profile/05461949321689249420noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-5472436831307966815.post-41125300690628834082013-03-21T11:24:21.149-06:002013-03-21T11:24:21.149-06:00@Greg, you can use the Text Lookup feature that we...@Greg, you can use the Text Lookup feature that we have offered since v2.0. <br /><br />Please let me know if you need further clarifications. <br /><br />Thanks,<br />Daniel CaiDaniel Caihttps://www.blogger.com/profile/05461949321689249420noreply@blogger.comtag:blogger.com,1999:blog-5472436831307966815.post-89750022675715861062013-03-21T10:16:11.790-06:002013-03-21T10:16:11.790-06:00Hi Daniel.
I am trying to adjust the Destination...Hi Daniel. <br /><br />I am trying to adjust the Destination in such a way it'll be able to update lookup. <br />I am getting the text value of the lookup from some external source and should set the CRM lookup to<br />this value. How do I go from here?Anonymoushttps://www.blogger.com/profile/06188203663140227108noreply@blogger.comtag:blogger.com,1999:blog-5472436831307966815.post-73104419955451812332012-07-02T11:41:42.273-06:002012-07-02T11:41:42.273-06:00Hi sandy, sorry for the slow response. To be hones...Hi sandy, sorry for the slow response. To be honest with you, I am not an expert on DQS in this perspective. As far as my experiment goes, SSIS Data Cleansing component doesn't provide de-dupe functionality. SQL Server Data Quality Client only supports limited types of connections, which are SQL Server, Excel file, and CSV file for destination. <br /><br />The most practical solution as far as I can see at this moment is to write some custom code to retrieve duplicates using CRM duplicate detection rules, then perform a merge for any duplicate records found using CRM SDK (MergeRequest).Daniel Caihttps://www.blogger.com/profile/05461949321689249420noreply@blogger.comtag:blogger.com,1999:blog-5472436831307966815.post-78718462725019604292012-06-28T16:42:33.421-06:002012-06-28T16:42:33.421-06:00Daniel, can sql server 2012 dqs be used to de-dupe...Daniel, can sql server 2012 dqs be used to de-dupe/remove duplicates in crm data? what about SSIS? how would either solution handle merging account records that have multiple contacts associated? do you have any other suggestions for automating de-duplication? thanks, sandyAnonymoushttps://www.blogger.com/profile/16280331951266416339noreply@blogger.com