- Part 1 – Introduction & Building the Back-End Reporting Database
- Part 2 – Developing SSIS Package to Import Data from SharePoint Lists to Reporting Database
- Part 3 – Setup SQL Server Agent Job to periodically execute the SSIS Package
- Part 4 – Building and Publishing Excel Reports on SharePoint
Update: I built the original version of this solution in 2010, but I am updating the solution with SSDT 2012.
This is an entire BI solution on Chinook sample database using SSIS, SSAS, and SSRS.
Credits: Enterprise SSIS Framework has been used to implement the ETL componments in this soluiton.
Please find Source Code here.