This project has two packages to load data from an Excel file to SQL Server. The data flows co The data is obtained from the Excel file. Variables are created to store the file paths. These variables ...

Create a SQL Server Integration Services (SSIS) package to load data from SQL Server into Azure SQL Data Warehouse. You can optionally restructure, transform, and cleanse the data as it passes through ...

Today’s guest blogger is CRM MVP Darren Liu who is a CRM specialist at Sonoma Partners in Chicago. I wrote a blog article last year on how to integrate Microsoft Dynamics CRM using SQL Integration ...

Another option is to consider using an SQL Server Integration Service (SSIS). It is one of the most common methods used to extract, transform, and load (usually abbreviated to ETL) data.

BlueFinity International recently demonstrated how to create a simple SSIS transformation to move MultiValue data into MS SQL Server using mv.SSIS in a free webinar on March 1.

Loading data from SQL Server using Power Query is fairly straightforward, and the basics are well-documented (see here for example). However there are a few advanced options, not all of which are c… ...

Business Apps Developers using PowerApps can now use the Power Query feature to create new entities and then load data into the Common Data Service based on data from a wide range of external data ...