Working with CRM Dynamics 2016 and SSIS – Step 1

Last year, when Microsoft had announced SQL Server 2016 they talked about Power Query integration in SSIS. From my point of view this was a great announcement for many reasons :

• Agile BI enhancements : when IT have to re industrialize personal BI solutions created by end users
•  IT enhancements : adding multiple native to connection to many sources that you have to script in SSIS

And that would have been a great scenario, when you have to put BI over a CRM (Dynamics for example). Unfortunately, this announcement has been deprecated before he born…. So how could you import CRM Dynamics data into your data warehouse with SSIS ?