Implement BDD functionality using RowIndex function in the SSIS Productivity Pack

02 September 2016
Daniel Cai

SSIS Balanced Data Distributor has been commonly used for distributing incoming rows to multiple SSIS destination components to help improve integration performance. However BDD comes with a few limitations. In this blog post, I will show you a better way to implement it without sacrifice from the those limitations.


Migrate Quote From One Dynamics CRM System to Another

16 August 2016
Chen Huang

In this blog post, we will showcase the best practices that you can use to migrate CRM quote data from one CRM organization to another.


Migrating old CRM KB Article data to the new Knowledge Article

21 June 2016
Chen Huang

In this blog post, we will demonstrate how to use our software to migrate old KbArticle data to the new knowledgebase along with taking care of the versioning issue by creating new knowledge records and updating the latest version of the existing article records.


Using CRM Alternate Key(s) for Lookup Purpose in SSIS

16 May 2016
Daniel Cai

CRM 2015 Update 1 introduced the Alternate Key feature which can be used for Update and Upsert function as an alternative way to identify a CRM record in addition to the primary key. However there is one more scenario that this feature can be useful as well, but may have been overlooked, which is to use the Alternate Key for lookup purpose. In this blog post, I will show you how we have enabled the feature for lookup purpose.


How to migrate CRM Recurring Appointments

11 May 2016
Chen Huang

We find it is quite tricky when working with recurring appointment. In this blog post, we will demonstrate how to migrate recurring appointment data. You may find it extremely easy to handle the tricky situation by using our software.


Changes required when making CRM Service Calls in SSIS Script Component

11 May 2016
Daniel Cai

In our most recent release of SSIS Integration Toolkit v7.1 for Microsoft Dynamics CRM, we updated our support for SSIS 2016 and 2014. With this release there is a requirement to update your script component in order to work with the latest release.


Solving the "Paging cookie is required" error

11 April 2016
Daniel Cai

When using FetchXML query to read data from Microsoft Dynamics CRM server, you might run into an error complaining "Paging cookie is required when trying to retrieve a set of records on any high pages". We have a solution for this error.


Upcoming SSIS & Integration Toolkit Training Courses

10 August 2015
Jessica Petta

Our next block of training courses are schedules to begin August 18th. Contact us now to reserve your spot!


Archive

Tags