Category Archives: SSIS

Fixed – ‘The attachment cannot be saved. Either specify activityId or ObjectTypeCode & ObjectId’ error while processing Email Attachment using SSIS

Introduction: While performing data migration most of the time, we need to migrate Email and Email Attachments, where we first migrate the Emails and then migrate the Email Attachments. However, when we did a run for this, we were facing the below error. ‘The attachment cannot be saved. Either specify activityId or ObjectTypeCode & ObjectId.’… Read More »

Copy ActualCloseDate and ActualRevenue when Migrating Opportunity in Microsoft Dynamics 365/CRM

Introduction: While migrating data for Opportunities, Quote and Order entities, the actualrevenue, actualclosedate, fulfilled date and closeddate are some of the fields that do not get mapped. Traditionally these fields are updated when the respective transactions are closed and the associated OpportunityClose, QuoteClose activity type records are associated at the time of closing these transactions.… Read More »

Migrate Views through SSIS in Dynamics CRM

Introduction: We can migrate both System Views as well as Personal Views through SSIS in Microsoft Dynamics CRM. Before we look at how this can be done through SSIS, let’s see what System and Personal Views are. System Views:System Views are those views, similar to Public views which are automatically created by Dynamics CRM on… Read More »

An error “The number of decimal places on the quantity is invalid” while migrating quote product through SSIS

Introduction: While migrating or creating the records for the Products and hence the Quote Products, Invoice Products, Order Products and Opportunity Products, we have to ensure the number of things as this would not allow us to create or migrate the data successfully in the CRM. For example, Price List, Unit and Unit Group etc.… Read More »

Error, ‘0 is not a valid CRM type code’ resolved in Dynamics CRM

Introduction: While migrating data of the custom entities and its associated records like activities, notes, etc. from the source system to the target CRM, a difference is observed in the regardingobjecttypecode for all the custom entities in the source as well as the target CRM. When the entity is created, a unique integer value, Entity… Read More »

Error ‘Principal user is missing prvReadAccount privilege’ resolved

Introduction: Data migration needs to carried out carefully when you are adopting a new system. If it doesn’t get the attention it deserves, then it can increase the exposure to several risks. During data migration, you might probably face various errors while transferring data. ‘Principal user is missing prvReadAccount privilege’ being one of the most… Read More »

Tip while migrating Products to Microsoft Dynamics CRM

Introduction Most CRM Implementations involve data migration from legacy system. This article is a tip for smooth migration of Product data to Dynamics CRM. Product Record mandatory fields As you know that the when we create the product in CRM, we select the Unit Group and the Default Unit on Product. Unit group is a… Read More »

Exporting Data from Dynamics CRM using SSIS

Introduction: We have often had sync requests projects where we need to write data from CRM to flat files. Our option until now had been to either Develop a Windows service, that polls at regular intervals to writes the file Develop a Windows app and using the windows task scheduler to schedule to run at… Read More »