12 Sep’19

Blog, D365 Sales, Dynamics 365, Dynamics CRM, OthersUsing For Each Loop in SSIS for Invoice Integration from SQL Server to Microsoft D365 Sales Using KingswaySoft Connector for CRM: Part 3

Part 3/4

SSIS Integration Map for Invoice Details from SQL Server to Microsoft CRM

Step 1:

Add a DFT to Integrate the Invoice Details in the Control Flow.

The Map after Completion looks as follows:

Step 2:

Add an OLEDB Source and configure it as following:

In our case we are Inner Joining Invoice and Invoice details Table based on OrderNumber and  Invoice Details and Products Table based on ProductID. This will help us to retrieve the columns which are not provided in a single Table and are required for Integration of Invoice Details.

(Note: this might vary according to your scenario)

Click on Parameters and configure it as follows:

Step 3:

Add a derived column transformation to create a unique name for Invoice Details as an upsert criteria.

Step 4:

Add a CRM destination Block and configure it as follows:

We will use Upsert Criteria specified on Invoice Detail Unique Name for Integration of Invoice Details. The fields mapped are as following.

Step 5:

Add an OLE DB command transformation to update the Ported status to 1 indicating the Invoice details have been integrated.

Configure it as follows:

Step 6:

Add the remaining blocks for Custom Error Handling as explained in the Blog in Link:

https://www.cloudfronts.com/creating-custom-error-log-table-in-ssis-for-oledb-block-and-kingwaysoft-dynamics-crm-block/

Note:

This is the third part of the 4 part blog series.

Part 1/4: Using FOR EACH Loop with KingswaySoft Connector for CRM Invoice Integration.

Part 2/4: SSIS Integration Map for Invoice Header from SQL Server to Microsoft CRM

Part 3/4: SSIS Integration Map for Invoice Details from SQL Server to Microsoft CRM

Part 4/4: Delete Logic for Invoice in case of Incomplete Integration of Invoice details Logic:

Written by

Rushank Karekar

Software Engineer

Leave a Reply

Your email address will not be published. Required fields are marked *

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Introduction to Microsoft Dynamics Commerce Tools

    19 October’ 2019

    As we know, Dynamics 365 Commerce is released in the preview version, So in this blog, we will have a quick explanation ...

    Read more
  • Error Handling Approaches for Integration

    16 October’ 2019

    Introduction: Handling Errors is a best practice in Integration when integrating to keep a track of the Errors that occu...

    Read more
  • Change in URLs for Business Central Tenants

    16 October’ 2019

    Change in base URLs for Business Central SaaS Tenants. I have noticed the Business Central links for Tenants have chan...

    Read more
  • Record Deletion Tool in Business Central

    16 October’ 2019

    Introduction: After a successful Go-Live in Business Central, we somehow need to delete a record from Backend. There is...

    Read more
  • Error “A reference to ‘xyz ‘ is required to compile this module” solution

    10 October’ 2019

    Many of the time while building project/solution we came across the “reference is required to compile this module ...

    Read more
  • We respect your privacy.
  • This field is for validation purposes and should be left unchanged.