基于三个字段从Microsoft CRM中删除记录(KINGSWAYSOFT) [英] Deletion of record from Microsoft CRM Based on three fields(KINGSWAYSOFT)

问题描述

我有平面文件源和动态crm目标.我必须从CRM删除一条基于Title(文本)，Startdate(文本)和userid(CRM中的查询字段)的记录，该记录是从Flatfile输入的.我该如何做到这一点.

I have flatfile source and dynamics crm destination.I have to delete a record from CRM based on Title(text), Startdate(text) and userid(lookup field in CRM) which is given as input from flatfile.Can you suggest how can I achieve this.

谢谢

推荐答案

您可以查看我们的 SSIS生产力包，它使您可以对CRM源执行查找.高级查找组件具有两个输入-主要输入和查找表输入.在您的情况下，您可以将平面文件源组件指定为主要输入"，并使用"CRM源"组件作为查找表输入".完成此操作后，您应该能够在匹配行"输出中获取对应的记录，该记录可用于推送到CRM目标组件并执行删除"操作.希望这会有所帮助.

You can take a look at our Premium Lookup component in the SSIS Productivity Pack, which allows you to perform a lookup against your CRM source. The Premium Lookup component takes two inputs - Primary Input and Lookup Table Input. In your case, you can specify the flat file source component as your Primary Input and use CRM Source component as the Lookup Table Input. With that being done, you should be able to get the corresponded records in the Matched Rows ouput, which can be used to pushed to the CRM Destination component and perform a Delete action. Hope this helps.

这篇关于基于三个字段从Microsoft CRM中删除记录(KINGSWAYSOFT)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！