kingswaysoft
Using KingswaySoft Azure Blob Storage component with Dynamics 365
Category: kingswaysoft,Microsoft Dynamics 365,SSIS Author: Nishant Rana Date: 1 week ago Comments: 0

KingswaySoft provides 3 components specific to Azure Blog Storage Azure Blob Connection Manager Azure Blob Storage Source Azure Blob Storage Destination Check other blog posts on SSIS https://nishantrana.me/2020/10/16/ssis-kingswaysoft-and-dynamics-365/ Let us take a simple example where we are extracting reading contact data from Dynamics 365 CDS and saving it as a text file in … Continue reading “Using KingswaySoft Azure Blob Storage component with Dynamics 365”
Source: Nishant Rana


Connect to Dynamics 365 through Script Component – SSIS
Category: Dynamics 365,kingswaysoft,Microsoft Dynamics 365,SSIS Author: Nishant Rana Date: 1 week ago Comments: 0

For complex data migration requirements, usually we’d be using 3rd party tools like KingswaySoft or Scribe, or Informatica as they already have components (connection, transformation, source, destination etc.) built for Dynamics 365 instead of building our own. Check other posts on data migration https://nishantrana.me/2020/10/16/ssis-kingswaysoft-and-dynamics-365/ https://nishantrana.me/2020/05/19/data-migration-in-dynamics-365-key-considerations/ For some simple / basic requirements instead of using 3rd … Continue reading “Connect to Dynamics 365 through Script Component – SSIS”
Source: Nishant Rana


Deploy and run SSIS Integration Toolkit for Dynamics 365 on Azure Data Lake (KingswaySoft)
Category: Azure,Azure Data Factory,Dynamics 365,kingswaysoft,Microsoft Dynamics 365,SSIS Author: Nishant Rana Date: 1 month ago Comments: 0

In the previous post, we saw how to deploy and run SSIS packages on the cloud. Here we take it one step further and will deploy and run the SSIS packages that use KingswaySoft’ s SSIS Integration Toolkit components. Here we will need an Azure Subscription, where we will host the SSISDB, followed by provisioning … Continue reading “Deploy and run SSIS Integration Toolkit for Dynamics 365 on Azure Data Lake (KingswaySoft)”
Source: Nishant Rana


Fixed – Script Component has encountered an exception in user code. Value cannot be null. Parameter name: keyword in SSIS
Category: Dynamics 365,kingswaysoft,Microsoft Dynamics 365,SSIS Author: Nishant Rana Date: 2 years ago Comments: 0

Recently while trying to use KingswaySoft’ s CRM Connection Manager in the Script Component we got the below error Turned out the issue was because of the wrong version of KingswaySoft.IntegrationToolkit.DynamicsCrm assembly being referred. C:WindowsMicrosoft.NETassemblyGAC_MSILKingswaySoft.IntegrationToolkit.DynamicsCrm Referencing the correct one fixed it. Hope it helps..
Source: Nishant Rana