Tags » SSIS

SSIS: Excel Connection Manager Error "Class not registered"

Recently, we were working on SSIS to get data from AX to the staging tables. As part of the requirement, we were also using Excel Connection Manager… 128 more words

SSIS

SSIS: Login failed for user "NT AUTHORITY\ANONYMOUS LOGON"

Recently, we were working on SSIS for ETL(Extract,  Transform and Load) to get the data from AX and push to the staging tables. We were using linked server for AX and we were using  97 more words

SSIS

SSIS: "The version number in the package is not valid. The version number can't be greater that current version number"

Recently, while working on SSIS to get data from AX and putting in our staging tables, we faced a weird compatibility issue between SQL Server and SSDT version we were using. 145 more words

SSIS

Using Conditional Split Transformation in SSIS

Recently we had a requirement to Upsert Customer’s Spend related information from SQL DB to our CRM Online.

We had the spend captured per brand wise in the DB as shown below. 143 more words

Microsoft Dynamics 365

Optimum Batch Size while using SSIS Integration toolkit for Microsoft Dynamics 365

Hi,

Recently while working in a data integration task, we were evaluating the performance of using KingswaySoft’s Dynamics 365 Toolkit from within Visual Studio by trying out different possible combinations of batch size and threads. 132 more words

Microsoft Dynamics 365

CRM service call returned an error: The server is busy and the request was not completed. Try again later while inserting records using CRM Destination Component of KingswaySoft’s SSIS Integration Toolkit for Dynamics 365

While running one of our package we got the below error in few of the records

“CRM service call returned an error: CRM service call returned an error: The server is busy and the request was not completed. 129 more words

CRM

Lookup not getting set while using CRM Destination Component of KingswaySoft’s SSIS Integration Toolkit for Dynamics 365

Recently while inserting a custom entity (Transaction) records using the CRM Destination Component we realized that Contact’s lookup was not being set.

We were using Alternate Key to set the lookup as shown below… 109 more words

Microsoft Dynamics 365