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.

Executing Snowflake Functions in SSIS ETL Processes

28 March 2022
KingswaySoft Team

The Snowflake command task that is a control flow level task can be used to easily execute functions in Snowflake and use it for further data flow executions.