Category: Integration Services

SQL Server Data Tools (SSDT-BI) for Visual Studio 2013 are back and available for download

SSDT-BI were down for almost a month after the release of the SQL Server 2014 causing a lot of frustration to the end users who were trying to develop BI solutions using Visual Studio 2013. No point of getting into the reasons why, let’s just take a deep breath and download the latest version here

Continue reading

Reading and Loading SharePoint Data using SSIS

Lists are one of the cornerstones of SharePoint and many companies have a wealth of information stored and managed using this SharePoint feature.  I sometimes get questions whether it is possible to extract that data (or load that data) into a data warehouse or a cube elsewhere.  The answer is yes, using the SharePoint SSIS Adapters. 

Continue reading