Construct ActivityParty JSON Values for Dataverse Activity Entity Migration

30 March 2022
KingswaySoft Team

In this blog post, we will show a simple solution that can be used to generate the JSON structure from database tables which can be sent to CDS/CRM destination components for writing, we demonstrate the use of SQL FOR JSON clause to achieve the purpose.


Query CDS/CRM Online Data using SQL Query in SSIS

20 November 2020
Chen Huang

In this blog post, we demonstrate how to connect to CDS/CRM Online SQL database through an ADO.NET Connection Manager and query data using the Premium ADO NET Source component, a part of our SSIS Productivity Pack.

 FetchXML   SQL   SQL2FetchXML   SSIS 

Using the Pre & Post Commands Feature in KingswaySoft Premium ADO.NET Components

19 November 2020
KingswaySoft Team

In this blog post, we demonstrate how to use the Pre & Post Commands feature in the Premium ADO.NET components to run SQL statements or set session variables before or after executing our components.


Error: The connection manager '' is not properly installed on this computer

20 August 2014
KingswaySoft Team

We have received a few reporting from our customers saying "The connection manager '' is not properly installed on this computer" when using SSDT-BI for Visual Studio 2013, this blog post tries to direct you to the download link which includes a fix for this issue.

 SQL   SSIS 

SSIS 2012 Error - 'Salt' attribute for PassWord is missing in the project manifest

31 May 2013
Daniel Cai

We have received a couple of reporting of the error mentioned in the title for SSIS Integration Toolkit for Dynamics CRM. We have done some preliminary investigation and we believe this is a SQL Server bug. Read for more information about the error and workaround solution.


Introducing SQL2FetchXML Online Converter

25 March 2013
KingswaySoft Announcement

Today, we are happy to announce that we have just launched a new website called SQL2FetchXML.com, which is a free online converter that helps convert SQL script into CRM FetchXML query.

Archive

Tags