Deleting Elastic Table Records in Dataverse Using Alternate Key in SSIS (KingswaySoft)
Had written a post on deleting the elastic table record earlier – How to Delete Elastic Table Records in Dataverse (SDK). We need to pass the partitionid value through an alternate key to delete the elastic table records. We will have the alternate key auto-created by the system when we create an elastic table. Earlier…
Data Migration of Quote and Quote Product – few key points (Dataverse/Dynamics 365/ SSIS)
Below are the different out-of-the-box statecode and statuscode for the Quote table. Status (statecode) Status Reason (statuscode) 0 (Draft) 1 (Inprogress) 1 (Active) 2 (Inprogress) 3 (Open) 2 (Won) 4 (Won) 3 (Closed) 5 (Lost) 6 (Canceled) 7 (Revised) Now if we are trying to migrate Quote records that are in either 2(Won) or 3(Closed)…
Fixed – CRM service call returned an error: An error has occurred when retrieving metadata for CRM entity ‘table’: The source argument contains duplicate keys – Dataverse/ Dynamics 365 / SSIS
Recently while trying to retrieve OptionSet Metadata using our favorite KingswaySoft SSIS Toolkit we got the below error. Same error for prod also – [CDS Source [2]] Error: An error occurred with the following error message: “KingswaySoft.IntegrationToolkit.DynamicsCrm.CrmServiceException: CRM service call returned an error: An error has occurred when retrieving metadata for CRM entity ‘copilotexamplequestion’: The…
Fixed – CRM service call returned an error: The number of decimal places on quantity needs to be 0 or less for Quote Product (Dynamics 365 / Dataverse/SSIS)
While running an SSIS Package that creates Quote Product records, we got the below error – CRM service call returned an error: The number of decimal places on quantity needs to be 0 or less If we see the decimal places seem to be specified properly for the quantity field in the source file as…
Using Homogenous Batch / Bulk operation messages for improved performance – Data Migration / Dataverse
As we all are aware Microsoft has introduced Bulk Operation messages in the platform. Now we could use the same in our SSIS Package that uses KingswaySoft’s SSIS Integration Toolkit for Microsoft Dynamics 365 by using the Homengeneous Batch Operation Messages option in the CDS / CRM Destination Component Editor. Let us first use the…
Using xMultiple along with User Multiplexing for improved performance – KingswaySoft SSIS Integration Toolkit (Dataverse / Dynamics 365)
Let us continue our previous post, where we observed performance improvements by using User Multiplexing Now let us try making use of the xMultiple feature (CreateMultiple, UpdateMultiple, and CreateMultiple messages) of the CRM / CDS Destination Component. We have updated the Batch Size to 100 to trigger the xMultiple However this time we got the…
How to use – User Multiplexing to get better performance for Data Migration /Integration using KingswaySoft Integration Toolkit for Dynamics 365 (Dataverse / SSIS)
Let us see how we can make use of User Multiplexing to get better performance. Below is our SSIS Package, which uses Data Spawner to create sample records, 20 K in this case, and CDS Destination to create those records (contact). Data Spawner is used to create the 20000 contact record. The CRM Connection is…
How to –Upload files to File Column / Attribute in SSIS from Azure Blog Storage – KingswaySoft (Dynamics 365 / CRM)
Below are a few ways we can upload files to the File Column type field using KingswaySoft’ s Integration Toolkit and Premium Flat File Source and Premium Derived column which are part of the SSIS Productivity Pack of KingswaySoft https://nishantrana.me/2022/03/17/how-to-upload-files-from-file-column-attribute-using-ssis-kingswaysoft-dynamics-365-crm/ Using the Import column – https://nishantrana.me/2022/08/10/how-to-upload-files-to-file-column-attribute-using-ssis-kingswaysoft-and-import-column-dynamics-365-crm/ Using the Script Component – https://nishantrana.me/2022/08/09/how-to-use-script-component-to-upload-files-to-file-column-attribute-in-ssis-kingswaysoft-dynamics-365-crm/ Here instead of…
How to – Use Import Column to Upload files to File Column / Attribute in SSIS KingswaySoft(Dynamics 365 / CRM)
A few weeks back had posted on how to upload files to the File Column type field using KingswaySoft’ s Integration Toolkit and Premium Flat File Source and Premium Derived column which are part of the SSIS Productivity Pack of KingswaySoft https://nishantrana.me/2022/03/17/how-to-upload-files-from-file-column-attribute-using-ssis-kingswaysoft-dynamics-365-crm/ Here we will see an example of achieving the same without using the…
How to – Use Script Component to Upload files to File Column / Attribute in SSIS – KingswaySoft (Dynamics 365 / CRM)
A few weeks back had posted on how to upload files to the File Column type field using KingswaySoft’ s Integration Toolkit and Premium Flat File Source and Premium Derived column which are part of the SSIS Productivity Pack of KingswaySoft https://nishantrana.me/2022/03/17/how-to-upload-files-from-file-column-attribute-using-ssis-kingswaysoft-dynamics-365-crm/ Here we will see an example of achieving the same without using the…
Something went wrong. Please refresh the page and/or try again.
Discover more from Nishant Rana's Weblog
Subscribe to get the latest posts sent to your email.
Share It -
Nishant Rana's Weblog 
12 thoughts on “SSIS (KingswaySoft) and Dynamics 365”