I can't count how many times I had to read quickly (for small oneshot script purpose) a CSV file which was coming from powershell, database, Excel or anything else. I can't count how many times I've wrote the following ugly & clunky lines public class data { public Guid column1; public »
In scope of our CRM Dynamics 2013 On premise to CRM Online migration, we had users who created dynamic Excel workbook based on CRM views. When switching environment, URL changed (to become xxxx.crm4.dynamics.com) which prevented existing workbooks to work. We found out no other way than edit »
Beginning : Where we are In few words, today we create an opportunity in the CRM, the data are retrieve with some SSIS package and consolidated on our SQL server, then Sharepoint is "eating" the data from SQL to create a Sharepoint site with the correct metadata, and to finish the »
In part 1 we retrieved the XML response of CRM Online odata without user interaction. Time that SSIS handle this XML. Making SSIS reading CRM XML Output Before spending effort on creating an SSIS Script component for authenticating & getting the output, let's check how SSIS understand the XML file »
Your reporting team is today retrieving CRM entities directly from On premise SQL server through SSIS packages. Quick & efficient. Your company is about to move to CRM Dynamics Online Disclaimer This blog post was possible with help of Basile (SSIS) & Clément (CRM / C# / SSIS) uh-oh, no more direct »