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
1
vote
1 answer

KingswaySoft - JSON Source component: how to set parent key on child nodes

I'm using the KingswaySoft JSON Source component that consumes a REST service which returns a Json with a Parent-Child structure. I linked two ADO.Net connection to the JSON Source output, to map the parent and child nodes to the corresponding…
M-S
  • 617
  • 7
  • 19
1
vote
1 answer

Why do I get the Error Message: "No modifications to the 'SYSTEM' or 'INTEGRATION' user are permitted.", when I add an Optional default Value?

I'm migrating some Database from SSMS to CRM Online. And the problem is, that there are systemuser in SSMS Database, which were deleted in CRM Online, or worse the systemuser has a new GUID. In this case I tried to look for similarities. I found…
M. Ulus
  • 11
  • 3
1
vote
1 answer

SSIS - RabbitMQ Source missing messages (KingswaySoft)

I am using an SSIS-Package with Kingsway's RabbitMQ components and I am experiencing some strange behavior when loading messages from a queue. I am processing an average of 2,500 messages per day and in some rare cases, single messages seem to be…
Stephan
  • 43
  • 1
  • 8
1
vote
1 answer

Convert Timezone to UTC SSIS package

I worked on creating a SSIS datamigration using kingswaysoft for Dynamics. i was tried to migrate createdon field from source to destination, once migrated there is a time difference of 12 Hrs, CRM time zone is set to GMT+12 for both source and…
Praneeth varma
  • 13
  • 4
1
vote
2 answers

SSIS consolidate and concatenate multiple rows into single rows without using SQL

I am trying to accomplish something that is pretty easy to do in SQL, but seemingly very challenging to do in SSIS without using SQL. Basically, I need to consolidate and concatenate a field of a many-to-one relationship. Given entities: …
Namkce
  • 504
  • 5
  • 16
1
vote
2 answers

SSIS Deployed Project validates Succesfully even with wrong Kingswaysoft Connection parameters

I deployed a SSIS project with a pre-configured Kingswaysoft connection, a project connection. I created different environments inside the SSISDB database, and I want to validate the project with every one of them. I intentionally set wrong…
Aleix
  • 431
  • 4
  • 20
1
vote
2 answers

FetchXML for SQL Join having filter

I am trying to build FetchXML equivalent of SQL query, I am quite new in using FetchXML: SELECT o.opportunityid,c1.accountid FROM dbo.opportunity o LEFT JOIN dbo.account c1 on o.customerid = c1.accountid and o.customeridtype = 1 into
Vijay Ande
  • 101
  • 11
1
vote
0 answers

SSIS ODBC Source update causing cast errors

I am running into an issue where every time I add a new column to my ODBC Source component I get the following error when I run it: Invalid character value for cast specification The only resolution I have is to remove the component and make it…
TemporaryFix
  • 2,008
  • 3
  • 30
  • 54
1
vote
0 answers

Importing data from public Google spreadsheet into SSIS?

I have been tasked with importing a google spreadsheet (which is public and accessible to everyone) into our data warehouse for analysis. I am just struggling on where to start? I have tried a a trial of Kingswaysoft which has a Google sheets…
Jess8766
  • 377
  • 5
  • 16
1
vote
1 answer

Request data from JSON API and store in SQL Server using SSIS

I'm trying to request data from a JSON API from Vemcount - a footfall-sensor system. I want to retrieve all my company's data and store it in a SQL Server db using SSIS. During my research I've realized that JSON is not natively integrated with…
Artem
  • 751
  • 2
  • 10
  • 30
1
vote
1 answer

Authentication Token Expires during Kingswaysoft integration with dynamics 365

We've built a data migration package that migrates data from a legacy Access database in to a CRM online instance. Our client has a quite complex authentication platform built around this, so we have had to use the Client ID and Client Secret method…
link64
  • 1,944
  • 1
  • 26
  • 41
1
vote
1 answer

Kingswaysoft SSIS Issue Premium Derived Column failed validation and returned error code 0xC0048021

ADDITIONAL INFORMATION: Error at Migrate Documents from Dynamics 365 Notes to SharePoint [Premium Derived Column [362]]: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for…
Pankil Bhatt
  • 11
  • 3
1
vote
2 answers

How to get scope identity column value in ssis using kingswaysoft

I am new to SSIS. I want to retrieve newly inserted value from destination CRM that is Identity column My source is SQL server and destination is CRM database
Ragunath Kalimuthu
  • 69
  • 1
  • 4
1
vote
2 answers

Using variables in "Dynamics CRM Source" fetchXML in SSIS

I am building SSIS package in that package I am using "Dynamics CRM Source" control which uses fetchXML to retrieve data from MS Dynamics CRM. This is my fetchXML:
asmgx
  • 7,328
  • 15
  • 82
  • 143
1
vote
1 answer

Unable to deploy project with Kingswaysoft 365 adapter to SSIS Catalog

I have an SSIS project where I am using Kingswaysoft 365 adapter as the destination in a package. It has a simple OLEDB to CRM dataflow task.The package works as expected in SSDT. However, when I try to deploy the project to SSIS catalog, I get this…
Rakesh
  • 65
  • 9
1
2
3 4 5 6 7 8