Split fullName into first- and lastname in SQL, Excel and SSIS
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...
Tagged: Excel
Using the KingswaySoft Duplicate Detector
KingswaySoft recently released their version 1.0 of the Productivity Pack which has some awesome features – and I will focus on one in particular in this blog post. The Duplicate Detector. I’ve already used...
Explode rows in SSIS
A request I receive more and more frequent from my customers, is the ability to create multiple rows based on a variable value in a field in CRM (for example, an integer or a calculation...