CRM, SSIS & Integrations ...configuring CRM as a non-coder
  • Home
  • Categories
    • Visual Studio
    • KingswaySoft
    • SSIS
    • JavaScript
    • CRM
    • SQL
    • ERP
    • Azure
    • How-to
    • Clubtimiser A/S
    • Office
    • Personal
  • About me
  • Privacy Policy
CRM, SSIS & Integrations
  • Home
  • Categories
    • Visual Studio
    • KingswaySoft
    • SSIS
    • JavaScript
    • CRM
    • SQL
    • ERP
    • Azure
    • How-to
    • Clubtimiser A/S
    • Office
    • Personal
  • About me
  • Privacy Policy
  • Home
  • Tag: SSIS

Homemade SSIS load balancer for large data load...

February 9, 2021 Written by Thomas

When you need to import hundreds of thousands records, it can take a long time to import with the KingswaySoft destination. This can be a serious issue, if a large data load is part of a scheduled running job. For this reason, it can make a lot of sense, to balance the load across multiple […]

CRM, How-to, KingswaySoft, SQL, SSIS, Visual Studio
Read More Leave a Comment

SSIS Basics: Merge join

January 20, 2020 Written by Thomas

For this small how-to, I’ll go through how to use the Merge Join in SSIS. The Merge Join is used for joining data into the a single row from two different datastreams. A basic example, where the MergeJoin can be used, is where you have a flat file with emails, and you need to locate […]

CRM, How-to, SSIS
Read More Leave a Comment

Installing Visual Studio 2017 and KingswaySoft

September 4, 2018 Written by Thomas

I have previously writting about an error I recieved when I attempted to installed SSDT for Visual Studio 2017. But with the new version of SSDT, Microsoft have seemingly fixed the bug, and you can now easily install SSDT with Visual Studio 2017. Firstly, you need the installer for Visual Studio 2017 (community works fine) […]

How-to, KingswaySoft, SSIS, Visual Studio
Read More Leave a Comment

Split fullName into first- and lastname in SQL,...

August 1, 2018 Written by Thomas

This is something I find myself doing over and over and over again, when importing data to CRM, seeing as CRM wants the contacts as Firstname and Lastname. And the data I receive is very rarely in that condition. So I find myself having to split the column fairly often – and I always forget […]

CRM, How-to, SSIS
Read More Leave a Comment

Using KingswaySoft to migrate ClickDimensions

August 1, 2018 Written by Thomas
ClickDimensions Logo

I was tasked with migrating a ClickDimensions solution from one Dynamics 365 to another Dynamics365 (both version 9.0). The only differences were, that it was a different CRM tenant and a newer version of ClickDimensions

CRM, KingswaySoft, SSIS, Visual Studio
Read More 7 Comments

Error installing SSDT for VS2017: Failed to acq...

May 3, 2018 Written by Thomas

I recently had to install VS2017 with KingswaySoft on a computer, and I ran into some issues in regard to the installation. After I had installed the Visual Studio software, I needed to install SSDT (15.5.0).

SSIS, Visual Studio
Read More Leave a Comment
Older Entries

The author

KingswaySoft MVP & Microsoft certified professional

My name is Thomas and I am a Senior Consultant at a company called netcompany A/S in Denmark. My primary focus is working with SSIS and KingswaySoft, where I perform integrations and datatranformations.

Click for more info

Recent Posts

  • Homemade SSIS load balancer for large data loads
  • Difference between two dates (SQL, SSIS and JavaScript)
  • Easy way to fetch row count for all tables in a SQL database
  • Create Application user in Azure for use in Dynamics 365
  • SSIS Basics: Merge join

Useful information

  • Installation guide to KingswaySoft
  • Software download list
  • CRM Object Type Codes
  • CRM State & Status codes
  • Script Repository

Archives

  • February 2021 (1)
  • May 2020 (1)
  • February 2020 (1)
  • January 2020 (2)
  • August 2019 (1)
  • May 2019 (1)
  • February 2019 (2)
  • January 2019 (2)
  • November 2018 (1)
  • September 2018 (1)
  • August 2018 (3)
  • May 2018 (4)
  • December 2017 (2)
  • August 2017 (1)
  • February 2017 (1)
  • November 2016 (4)
  • October 2016 (1)
  • September 2016 (2)
  • August 2016 (5)
  • June 2016 (4)
  • May 2016 (3)

Useful blogs/links

Henrik Jensen, my good friend and colleague, has a blog regarding EVERYTHING Dynamics crm. He's got 50+ certifications, and he is a force to be reckoned with. Link to his blog (danish): crmblog.dk

KingswaySoft have developed an outstanding piece of software for datamanagement to and from CRM, and I can recommend this toolkit for nearly every situation. Link to their website: kingswaysoft.com

Tag Cloud

Azure Bug CRM 2015 CRM 2016 CRM Online Data Dynamics365 ERP Excel How To JavaScript KingswaySoft Log News Office Outlook Personal Solution SQL SSIS Visual Studio

Categories

  • Azure (2)
  • Clubtimiser A/S (1)
  • CRM (31)
  • ERP (2)
  • How-to (15)
  • JavaScript (3)
  • Office (3)
  • Personal (4)
  • SQL (3)
  • Visual Studio (24)
    • SSIS (24)
      • KingswaySoft (15)

Disclaimer

The information given on the website is tested on a mixture of live production environments and test environments, and therefore I cannot guarantee my information will work for you, if you attempt to follow my steps.
If you experience problems, please feel free to contact me.

@June 7th 2016