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

Creating a generic package for dataload to crm

I am trying to create a generic ssis package using kingswaysoft and script task in ssis where I am passing lists of tables and getting the schema of the table from database in the script task now I want this schema output to be accessible in the…
Suman N
  • 9
  • 2
0
votes
2 answers

KingswaySoft SSIS error when Published - A password is required

I've created a package that gets some information from a sql database and inserts them into Dynamics CRM. When testing the package from Visual Studio everything goes as expected and the task finishes without any errors and the rows get inserte .…
upTheIrons
  • 65
  • 1
  • 7
0
votes
1 answer

Is there a better way to map using Flat File in SSIS

I am migrating data to a Dynamic 365 database from a CSV file using flat file source in SSIS(kingswaysoft), most of have the data has migrated, but some fields failed. The error being that, it was trying map the column values close to the one it is…
Victor Onyebuchi
  • 99
  • 10
0
votes
1 answer

Kingswaysoft SSIS create Contacts Slow

I’m currently doing some testing for an upcoming data migration project and came across Kingswaysoft which seemed like it would be ideal for this purpose. However I’m currently testing importing 225,000 contact records into a new sandbox Dynamics…
user2425239
  • 19
  • 2
0
votes
2 answers

Moving SQL server data into Dynamics 365 CRM

I have more than 500s of tables in SQL server that I want to move to Dynamics 365. I am using SSIS so far. The problem with SSIS is the destination entity of dynamics CRM is to be specified along with mappings and hence it would be foolish to create…
Sahil Tiwari
  • 159
  • 2
  • 12
0
votes
1 answer

While migrate date in to CRM it stores date with 4 hours ahead

While Migrate data in to CRM it saves date and time with 4 hours ahead. Is it possible to save date as same as source.
Ragunath Kalimuthu
  • 69
  • 1
  • 4
0
votes
0 answers

JSON Parse key to a table column SQL Server 2016

We are receiving this JSON document and importing into SQL Server 2016 using Kingswaysoft JSON Source component { "Program": "USRMI", "Transaction": "GetUserInfo", "Metadata": { "Field": [ { "@name":…
dazcuk
  • 1
  • 1
0
votes
1 answer

Exception of type 'System.OutOfMemoryException' Diff Detector Kingsway Soft

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Diff Detector" (501) failed with error code 0xC02090F9 while processing input "Old Data Input" (510). The identified component returned an…
Yaroslav Zghurovskyi
  • 1
  • 3
0
votes
1 answer

optimize number of record insert in to crm using kingswaysoft

i am trying insert more than 1 million record from sql server to crm it takes 2 hours for inserting 50,000 records is this normal or can we optimize this one because i dont have knowledge on crm before any suggestion is highly appriciate
Ragunath Kalimuthu
  • 69
  • 1
  • 4
0
votes
0 answers

Issue importing data with date from CRM

Recently i'm importing data from CRM dynamics 11 to our sql database on daily basis. I have created an SSIS package which does the import. My issue is in CRM i have member's date of birth as "1990-04-25" but when i import it to our sql database, it…
Biswa
  • 331
  • 6
  • 22
0
votes
1 answer

Dynamically decide columns in SSIS connectors for salesforce

I want migrate data from salesforce to SQL server and I am using SSIS connectors for salesforce. I am creating single SSIS package which fetch data for all objects and insert into SQL server. I tried using following connectors for…
Satishakumar Awati
  • 3,604
  • 1
  • 29
  • 50
0
votes
1 answer

How to retrive more than 5000 record from CRM using kingswaysoft for SSIS packages?

I am trying to migrate data between two CRM databases(dynamics 365) but when in kingswasoft there is limit of 5000 record per batch. can anyone please suggest an approach wherein I can send n number of records?
valredr
  • 21
  • 3
0
votes
1 answer

KingswaySoft data migration from Dynamics crm 4.0 to 365 id not exist error

I have already migrated the contact and account tables. There is a table in Extensions and I tried to migrate it, while it contents fields link to other tables like Contact. When I try to migrate, an error happen and it says an id of this table does…
autopenta
  • 57
  • 5
0
votes
1 answer

JSON Destination component error in Kingswaysoft

Am using JSON destination component to perform DELETE , it is a bit weird that the delete is successful when I saw in UI but am receiving the following error. [JSON Destination [15]] Error: An error occurred with the following error message: …
kanna
  • 73
  • 6
0
votes
1 answer

SSIS Kingswaysoft error for JSON source

I am using JSON Source component in a package, it is working fine on my local machine but when I deploy in server am receiving the following error. System.ArgumentException: Value does not fall within the expected range. at…
kanna
  • 73
  • 6
1 2 3 4 5
6
7 8