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

Excel to Dynamics CRM data import using SSIS package

I have created a SSIS package for data import from excel to dynamics CRM but now i want to put 2min wait condition for one row to another row import. eg: i have 10 records in excel sheet, it should import first row and has to wait 2 min for another…
Chaitanya
  • 1
0
votes
0 answers

SSIS ADO.NET Destination Error Output Not Working

I have a source component pulling data from an api and pushing it to an ADO.NET destination (from Kingswaysoft productivity pack). The ADO.NET destination is configured to redirect errors to a derived column and then to an error log SQL table, but…
M-S
  • 617
  • 7
  • 19
0
votes
1 answer

Performing Text Lookup with GUID as an input in Kingswaysoft Dynamics 365 Toolkit

In Kingswaysoft's Dynamics 365 Integration Toolkit, is there any way to lookup/match CRM ownerid GUID from source table to a custom column in destination's user entity? My problem For some reason, I have to perform a text lookup from source…
Khadim Ali
  • 2,548
  • 3
  • 33
  • 61
0
votes
1 answer

KingswaySoft JSON Source Component: Paging REST requests in SSIS using HTTP header field

I'm using the JSON Source Component to consume a REST service which returns page info and total records count on a particular field on the header response: X-JSON: {"total":1952,"results":100,"limit":100,"skip":0} Based on KingswaySoft…
M-S
  • 617
  • 7
  • 19
0
votes
1 answer

KingswaySoft: Premium Look up date retrieved throwing an error

I'm using the Premium Lookup to match some data. the query I'm using in the component is :
MChem
  • 1
0
votes
1 answer

SSIS Dynamics CRM to Dynamics AX Integration

We are currently working on the integration between Dynamics AX to Dynamics CRM and viceversa. In the direction of Ax to CRM, we have SQL queries which joins multiple AX tables and using the result of the JOINS query we are able to map all fields to…
Abhilash
  • 1
0
votes
0 answers

I am trying call an action in Dynamics CRM from KingswaySoft SSIS add-in and capture the response data and save to a database table

We have a Dynamics CRM action that we want to call from a KingswaySoft SSIS task and save the response data to a table. The response is a single record. I can't seem to get the KingswaySoft SSIS source to be an action. I wonder if it needs to be…
Mat
  • 1
0
votes
1 answer

Filter in NAV Source component , datetime

I need to provide the "last 7 days" filter in NAV Source component, I have to use the XML encoded values. I know that the date of today is "h", so how can I encode to write "last 7 days"? I'd tried to write "(h-7) but it's wrong.
AGR
  • 1
0
votes
0 answers

KingswaySoft: Nav source component filter InvoiceLines

I need to filter the Invoice Lines so that it only reads the lines where the Invoice Header exists. For instance: where InvoiceId in (Select InvoiceId from PostedSalesInvoices) Is it possible to encode it with XML? Thanks a lot
AGR
  • 1
0
votes
1 answer

KingswaySoft Upsert Bad Request

I am currently using KingswaySoft for ETL into Dynamics. We have a need for the upsert action for future trickle loading. Each time I use upsert on a entity (table in dynamics), that has data in it already, I am facing a bad request error. [Dynamics…
Stay Breezy
  • 1
0
votes
1 answer

KingswaySoft: Nav source component filter

I can't make filter to No field (Nvarchar type). I need to filter record with diferent value at 624. I'd tryied with code: <>'624' The error that show me: Detailed Message: Soap message is invalid!.Do someone help me?Thanks
AGR
  • 1
0
votes
0 answers

KingswaySoft Google Cloud Storage Source component missing parameter

I cant find a solution on how to provide the missing parameter in KingswaySoft Google Cloud Storage Component Editor. Anyone KingswaySoft Google Cloud Storage Component…
Lelouch Lamperouge
  • 1
0
votes
0 answers

Package Execution fails on SSISDB with Error "Unable to create the type with the name DynamicsCRM"

I am facing issue in executing from packages from Azure-Integration Runtime. It was working fine 3 months ago but now I am getting this error "Unable to create the type with name Dynamics CRM" I have reinstalled all the software related to…
roshni c
  • 1
0
votes
1 answer

Kingswaysoft Error Connecting to CRM On Premise

I have an SSIS package that updates a custom entity in CRM (On-Premise - 8.2). The package uses the Kingswaysoft WebAPI method to connect to CRM. When I deploy and try executing it from the server it gives the following error. I am not able to get…
ganeshkashim
  • 1
  • 1
0
votes
1 answer

SSIS unable to access the component's advanced editor

I am using the Kingswaysoft connection manager to manage Oauth2 for the DocuSign rest API. My JSON source component is throwing the below error: "The output value for 'name' systemField does not fit into the output buffer, please consider…
Matt West
  • 11
  • 1
1 2 3
4
5 6 7 8