User Review0 (0 votes)
In our previous post, we created the SSIS Catalog (SSISDB) in Azure and deployed the SSIS package using SSDT. Supported version for SSDT – SQL Server Data Tools to deploy SSIS package to Azure. For Visual Studio 2017, version 15.3 or later. For Visual Studio 2015, version 17.2 or later. In this post, we’d use … Continue reading “Using SQL Server Management Studio to deploy and run SSIS package in Azure Data Factory”
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)”
Before the SSIS package can be deployed to Azure Data Factory we need to provision Azure-SQL Server Integration Service (SSIS) runtime (IR) in Azure Data Factory. In the previous posts, we had created an Azure data factory instance had used Azure SQL Database as the source. Within Azure Data Factory in the Let’s get started … Continue reading “Deploy and run SSIS package in Azure Data Factory”
At times we need to generate sample data for our entities in Dynamics 365 for various reasons, performance testing is one of them. Data Spawner component which is part of KingswaySoft’s SSIS Productivity Pack provides us the most efficient way of doing so. Download the component here – https://www.kingswaysoft.com/solutions/ssis-data-generation-anonymization-components/data-spawner-component Let us generate the sample data … Continue reading “Using Data Spawner component (SSIS) to generate sample data in Dynamics 365”
Let us take a very simple example to understand how to migrate the multi-select option set in Dynamics 365. Few points to consider before we use Multi-select option set https://nishantrana.me/2018/04/27/limitations-of-multi-select-option-sets-in-dynamics-365-ce/ Here we will take excel as our source. Create a new SSIS package, add the Excel Source component and Dynamics CRM Destination component in the … Continue reading “Migration of multi-select option sets in Dynamics 365 – SSIS (KingswaySoft)”
We might get the error while using Derived Column in our SSIS Package To fix it right click the Derived Column component and select Show Advanced Editor .. Go to Input and Output Properties tab, expand Derived Column Output and select the field and update the length in the properties window. Hope this helps..
Recently I had written an article for Nigel Frank that list down step by step process of using XML Source Component of KingswaySoft for integration with Dynamics 365 CE https://www.nigelfrank.com/blog/integrate-dynamics-365-for-customer-engagement-with-xml/ We have used XML Source Component to read the XML files. The packages that we developed were running fine from Visual Studio SSDT but on … Continue reading “Fixed – DTS_E_PROCESSINPUTFAILED. The Process input method on component “Script Component” failed with error code 0x80131501 in SSIS”
Recently after deploying the SSIS packages, on one of the packages that uses Script Component, we started getting below error message This happened because SSIS packages had target version SQL 2017 and the SQL Server version was 2016 (select @@VERSION) The fix is to update the target version that matches the SQL Server Version. Right … Continue reading “Fixed – The Script Task uses version 15.0 script that is not supported in this release of Integration Services”
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:\Windows\Microsoft.NET\assembly\GAC_MSIL\KingswaySoft.IntegrationToolkit.DynamicsCrm Referencing the correct one fixed it. Hope it helps..
Something went wrong. Please refresh the page and/or try again.