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.

(1) Answer