Construct ActivityParty JSON Values for Dataverse Activity Entity Migration
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
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.
Using the Pre & Post Commands Feature in KingswaySoft Premium ADO.NET Components
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
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.
SSIS 2012 Error - 'Salt' attribute for PassWord is missing in the project manifest
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
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.