SSIS
Using SQL Server Management Studio to deploy and run SSIS package in Azure Data Factory
Category: Azure Data Factory,Dynamics 365,Microsoft Dynamics 365,SSIS Author: Nishant Rana Date: 1 week ago Comments: 0

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”
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 week 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


Deploy and run SSIS package in Azure Data Factory
Category: Azure,Azure Data Factory,Azure Data Lake,Dynamics 365,Microsoft Dynamics 365,SSIS Author: Nishant Rana Date: 1 week ago Comments: 0

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”
Source: Nishant Rana


Using Data Spawner component (SSIS) to generate sample data in Dynamics 365
Category: Dynamics 365,Microsoft Dynamics 365,PowerApps,PowerPlatform,SSIS Author: Nishant Rana Date: 4 months ago Comments: 0

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”
Source: Nishant Rana


Migration of multi-select option sets in Dynamics 365 – SSIS (KingswaySoft)
Category: Dynamics 365,Microsoft Dynamics 365,SSIS Author: Nishant Rana Date: 10 months ago Comments: 0

Let us take a very simple example to understand how to migrate the multi-select option set in Dynamics 365. 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 Data Flow. https://www.kingswaysoft.com/products/ssis-productivity-pack https://www.kingswaysoft.com/products/ssis-integration-toolkit-for-microsoft-dynamics-365 Specify the source file path. Here Favourite … Continue reading “Migration of multi-select option sets in Dynamics 365 – SSIS (KingswaySoft)”
Source: Nishant Rana


Error: The “Derived Column” failed because truncation occurred, and the truncation row disposition on “Derived Column.Outputs[Derived Column Output].Columns[FilePath]” specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
Category: SSIS Author: Nishant Rana Date: 1 year ago Comments: 0

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..
Source: Nishant Rana


Fixed – DTS_E_PROCESSINPUTFAILED. The Process input method on component “Script Component” failed with error code 0x80131501 in SSIS
Category: Dynamics 365,Microsoft Dynamics 365,SSIS Author: Nishant Rana Date: 1 year ago Comments: 0

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”
Source: Nishant Rana


1 2