Add the filter condition to retrieve the required data only based on GUID
Hi , I am using Dynamics 365 adapter to connect 2 CRM systems.
Whenever a record is deactivated in first instance, I need to send the same record to second instance.
For this, I configured Message Queue which triggers the DTS package.
In the DTS package, I have done the source and target mapping.
Now, the problem is , the DTS pacakge is retriving all the records from source CRM system. I need to add the filter to get the only record which got deactivated.
Please help me how to add the filter condition in the source query.