{"id":13315,"date":"2018-11-08T16:39:23","date_gmt":"2018-11-08T11:09:23","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=13315"},"modified":"2018-11-08T16:39:23","modified_gmt":"2018-11-08T11:09:23","slug":"how-to-set-all-party-list-values-while-migrating-data-of-activities-using-ssis-with-kingsway-soft-tool","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2018\/11\/how-to-set-all-party-list-values-while-migrating-data-of-activities-using-ssis-with-kingsway-soft-tool\/","title":{"rendered":"How to set all Party list values while migrating data of Activities using SSIS"},"content":{"rendered":"

While doing data migration of Activity entities like Email, Phone call which has Party list fields like to, from, bcc, cc etc. where we set all values i.e. lookups of different entities like Account, Contact, Lead, User, Queue etc. and manually entered an email address for e.g. abc@gmail.com<\/a>. While setting these party-list values, I was unable to set manually entered email address value because it is not an entity, it is a simple field which holds values in backend.<\/p>\n

The main cause behind this is while setting other lookups like account, contact etc. we have logical name of entities and its object type code i.e. account has 1, contact has 2 etc., But in case of manually entered email address we do not have its logical name because it is a Field, so due to this while setting the party list data I was unable to set such values in it.<\/p>\n

This blog will help you to fix this issue and how to set all party list values including address used<\/strong> value while migrating Activities data.<\/p>\n

Solution:<\/h2>\n

To set all values of party-list field we used Script <\/strong>component where we to write a code that will update the records. To achieve this we followed below steps:<\/p>\n

Step 1:<\/h2>\n

Initially, we need to create project level connection parameters as shown in below screenshot:<\/p>\n

\"How<\/p>\n

Step 2:<\/h2>\n

Once connection parameters created then we need to create SSIS package for activity for e.g. Email<\/strong> where we will create email record in Destination CRM as highlighted in below screen clip:<\/p>\n

\"How<\/p>\n

While creating record in Destination CRM, initially we need to remove mapping of party list fields as shown in below screen clip:<\/p>\n

\"How<\/p>\n

Step 3:<\/h2>\n

Once record created in Destination CRM after then we need to update party list values of record in Destination CRM, for that follow below steps:<\/p>\n