Stack Overflow
Stack Overflow

Questions tagged [kingswaysoft]

Use this tag to ask questions about KingswaySoft data integration software.

KingswaySoft makes data integration software, their primary product line offers data integration solutions utilizing Microsoft SQL Server Integration Services (SSIS) capabilities.

SSIS Integration Toolkit offers data integration solutions for enterprise applications. Their most popular solution is the SSIS Integration Toolkit for Microsoft Dynamics 365 which includes components for Dynamics 365, CRM, AX, & NAV. Other toolkits include Salesforce, NetSuite, Marketo, Dynamics GP & SL, and many others.

Included in the suite of solutions for SSIS is the SSIS Productivity Pack, this is a premium collection of SSIS components for productivity and connectivity. There are dozens of SSIS add-on components available within this pack including premium versions of out-of-box components which offer greater functionality and flexibility. The pack also includes some unique components not found anywhere else such as Duplicate Detector and Data Anonymizer. There are also several cloud and database connectivity solutions including components to facilitate integration with any web API (including REST) as well as NoSQL databases.

107 questions
5
votes
1 answer

Resolve SSIS Package with Kingswaysoft error: Connection type "DynamicsCRM" is not recognized as a valid connection manager type

I am using visual-studio-2015 to create an ssis package targeted at sql-server-2012. I am using KingswaySoft to connect to dynamics-crm to read & update some data. My package runs correctly when I run it from Visual Studio. However, when I deploy…
Tim Hutchison
  • 3,483
  • 9
  • 40
  • 76
3
votes
2 answers

Is there way to update modified on, created on and created by fields in CRM?

I need to update modifiedon, createdon, modifiedby in CRM using SSIS via kingswaysoft. Is it possible? Because right now kingswaysoft is not showing these fields for mapping.
Ragunath Kalimuthu
  • 69
  • 1
  • 4
3
votes
1 answer

SSIS Kingswaysoft CRM Destination Update Error .. ExecuteMultiple Request batch size exceeds the maximum.. Err -2147220715

When using a flat file to update a field on the account entity, no matter what I put in for Batch size I get that number of rows that get the below error: ExecuteMultiple Request batch size exceeds the maximum batch size allowed!(Error Code:…
qoq
  • 31
  • 1
2
votes
1 answer

SSIS destination component failing due to current version of the data flow

I have a working SSIS package. It works from vs, meaning it builds and executes as expected producing results in the CRM. After I get the generated .ispac file and deploy it in MSSQL server, I fail on executing. I get an error that looks like…
magicalKhachapuri
  • 563
  • 5
  • 19
2
votes
1 answer

SSIS with large amount of data slow and bad Performance via Kingswaysoft

We have lots of SSIS packages that update/create records in a CRM. Some entities like contact, account, customer product (our custom entity to hold all account types), while we are migrating records facing with slow performance and high CPU in SQL…
Hasret Taskin
  • 21
  • 1
2
votes
1 answer

How to merge source rows using SSIS Kingswaysoft without using a temp table

I have a source table with multiple rows of data but with no header row. I need to migrate this data to D365 CRM as two entities; A header entity and the corresponding content/rows entity. Is there any way to create the header entity in…
acolene
  • 91
  • 2
  • 8
2
votes
1 answer

Destination Entities are not appearing in CRM SSIS Destination Editor

I am using Kinswaysoft to migrate data from OLE DB to Dynamics CRM (on-premise). Now in CRM destination editor, the Destination Entity is empty and it throw below error: Failed to retrieve CRM entities.…
Mohsin A.
  • 153
  • 2
  • 18
2
votes
1 answer

Do record types affect the performance of a migration with kingswaysoft?

I have a migration I am running with about ~10 tasks. Each task takes about 5 minutes to process 50k-100k records and migrate them to salesforce. One task in particular is taking a much longer time to process than the other tasks. This task is…
TemporaryFix
  • 2,008
  • 3
  • 30
  • 54
2
votes
1 answer

Does anyone have an issue with Visual Studio 2015 Data Tools crashing when running package?

I can build SSIS packages without any issues, but almost every time I run the package from Visual Studio it will crash. Sometimes it will crash within seconds of running the package, other times it will run a few minutes and then crash. The only…
lessthancommon
  • 165
  • 8
2
votes
1 answer

The version of Dynamics CRM Source is not compatible with this version of the DataFlow

I'm running SSIS w/ Kingswaysoft on latest version of VS2017. I have created a package that executes successfully on my local computer and I have also successfully deployed the project deployment file via Integration Services Deployment Wizard to a…
Marius Holm Enerud
  • 21
  • 1
2
votes
1 answer

SSIS Custom component salesforce source (kingswaysoft) not configured properly via BIML

I am trying to connect to Salesforce using using kingswaysoft SSIS connector. I am able to successfully connect to Salesforce using Microsoft visual studio GUI in Data Integration project and retrive the data from salesforce. Because I have to…
Satishakumar Awati
  • 3,604
  • 1
  • 29
  • 50
2
votes
1 answer

SSIS package is not working as expected

We have very strange scenario, in fact don't understand how the SSIS execution flow is triggering the package tasks well to summerize the issue, we have create a SSIS package to push data to Dynamics CRM instance, and we created a SQL job which…
Murali Ramakrishnan
  • 856
  • 7
  • 7
2
votes
2 answers

How to upload files to one drive using ssis?

I am looking for a way to upload files to One Drive using SSIS. I've researched and there are some third party tools like CozyRoc, KingswaySoft which provide one drive connection manager. Anyone out there who already have experience doing this? If…
A Chow
  • 61
  • 2
  • 6
1
vote
0 answers

Getting error in KingswaySoft.IntegrationToolkit.AzureBlobStorage.AzureBlobStorageServiceException in Azure Blob Storage Destination

Trying to upload a file from Flat File Source to Azure Blob storage using Azure Blob Storage destination using KingswaySoft Integration tool kit. Steps followed: Created Azure Storage connection which is working fine But the task is giving error…
Kanika
  • 11
  • 2
1
vote
1 answer

Attributes in Linked Entities in FetchXML Kingswaysoft SSIS returning NULL

I am trying to migrate quote details using the Kingswaysoft SSIS CRM migration package from CRM2016 on premise to D365. To read the data I am using Fetch XML, on the quotedetails entity and want to link to the quote entity to retreive quotenumber…
Dave Ichiban
  • 11
  • 2
1
2 3 4 5 6 7 8