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
0
votes
0 answers

SSIS How to read and convert data to currency type?

I have the following JSON source file [ { "AccountNumber": 123456, "Balance": 745.000283 }, { "AccountNumber": 895686, "Balance": 0.241000 }, { "AccountNumber": 789876, "Balance": -.000125 } ] How to read and…
Толик Козедубов
  • 1
0
votes
1 answer

CRM Destination not showing all the fields in column in kingswaysoft

I am facing an issue while I am mapping the column fields CRM Source to CRM destination in Kingswaysoft. I am Migrating data for mailbox entity but Destination column is not showing all the fields which are present for mailbox entity. Could anyone…
amar bisht
  • 51
  • 10
0
votes
1 answer

SSIS Kingswaysoft productivity kit: diff detector

I am using Diff Detector from Kingswaysoft productivity kit. I have a question about the business key. Both my inputs (old and new) are from CRM SQL server views and therefore I would like to use the primarykey (accountid) as the business…
Rakesh
  • 65
  • 9
0
votes
1 answer

Deletion of record from Microsoft CRM Based on three fields(KINGSWAYSOFT)

I have flatfile source and dynamics crm destination.I have to delete a record from CRM based on Title(text), Startdate(text) and userid(lookup field in CRM) which is given as input from flatfile.Can you suggest how can I achieve this. Thanks
kanna
  • 73
  • 6
0
votes
2 answers

SSIS(Kingswaysoft):Two different metadata sources into single destination

Is it possible to have flatfile and JSON source as inputs to a JSON destination?
kanna
  • 73
  • 6
0
votes
1 answer

Security Timestamp Error in Dynamics CRM for Kingswaysoft

I'm getting this error in Kingswaysoft System.Exception: An error occurred when updating the component's output columns based on the most recent CRM metadata: KingswaySoft.IntegrationToolkit.DynamicsCrm.CrmServiceException: CRM service call…
CamJohnson26
  • 1,119
  • 1
  • 15
  • 40
0
votes
1 answer

Issues with migrating Mailbox records from one CRM to another CRM organization using kingswaysoft

I am migrating data from one CRM organization to another CRM organization. I am facing issues in migrating mailbox records. When User is created in Source CRM it creates two mailboxes and I am trying to migrate these two mailboxes to target CRM but…
Manish Pandey
  • 175
  • 2
  • 13
0
votes
1 answer

Kingswaysoft Salesforce Upsert Upsert External Id Field

I have a simply SSIS package that creates Salesforce data from an Excel spreadsheet. I want to convert the package to use Upserts, but I get an error after selecting the Upsert function. It says Error: Upsert ExternalId Field was not…
CamJohnson26
  • 1,119
  • 1
  • 15
  • 40
0
votes
2 answers

Kingswaysoft Metadata Fields Return Null

Is there a bug in Kingwaysoft where some metadata fields return null? I have a large project downloading all account fields and metadata, and they all work except for owneridtype and a few others. Fields like customertypecodename come over fine, and…
CamJohnson26
  • 1,119
  • 1
  • 15
  • 40
0
votes
1 answer

How do I debug CRM Connection Error in SSIS Package?

I am using KingswaySoft to connect to Microsoft Dynamics CRM in an SSIS Package using Visual Studio 2015. I am receiving the following error when I try to run the Package on the server. Data Flow Task:Error:…
Tim Hutchison
  • 3,483
  • 9
  • 40
  • 76
0
votes
1 answer

How to collaborate on visual studio

I am currently working An SSIS project in visual studio that requires multiple people to work on it. We currently use GIT to get the information around, but one of the components, specific KingswaySoft Salesforce component, throw authentication…
Franco Pettigrosso
  • 4,056
  • 2
  • 20
  • 32
0
votes
3 answers

SSIS CRM11 upsert record

Can anyone help me for upserting the record in CRM11 using kingswaysoft crm connector ? I have an excel sheet which contains employee number and other details, not any guid. I need to insert or update these data in CRM11. Do we need guid to update…
Anish
  • 588
  • 6
  • 21
0
votes
4 answers

Error when setting statecode to inactive using KingswaySoft/SSIS

When performing and update statecode to inactive using SSIS and the KingswaySoft adapters I get the below error. Are there any suggestions to resolve this issue? CRM service call returned an error: CRM service call returned an error: An unexpected…
user3845056
  • 489
  • 7
  • 25
0
votes
1 answer

Navision 2015 get record after insert with page web service

I am using SOAP web service to insert the record into Navision with KingswaySoft SSIS component. One thing is realy bugging me. The KingswaySoft destination NAV component returns Key and IsNew values. I try to use the Key to retrieve the inserted…
Tom
  • 373
  • 3
  • 10
-1
votes
1 answer

Error in Integration Services Catalog about the REST API

I worked on extracting data from Jira, using the kingswaysoft Rest Api. It workes fine while on Visual Studio but, once i deploy it to Management Studio, i get an error stating: Data Flow Task:Error: An error occurred with the following…
Henrique Abreu
  • 1
1 2 3 4 5 6
7
8