This category contains 10 posts

SSIS 2016: Empty toolbox?

I recently upgraded several SSIS packages from VS2010 (SSIS 2008R2) to VS2015 (SSIS 2016). After the initial upgrade\conversion when I opened the package(s) I noticed that the Toolbox pane was empty, displaying a “There are no usable controls in this group.  Drag an item onto this text to add it to the toolbox.”.  What???  Where … Continue reading

Customizing SSRS Subscription Schedules

How frustrating is it when setting up an SSRS report subscription to be stuck with the standard  run times Daily, Hourly etc. With no options for adjusting or customizing the schedule to lets say just running during core business hours or exclude weekends etc. I have always found this to be a major shortcoming of … Continue reading

Top 10 Best Practices for Building a Large Scale Relational Data Warehouse

    Top 10 Best Practices for Building a Large Scale Relational Data Warehouse Building a large scale relational data warehouse is a complex task. This blog post describes some design techniques that can help in architecting an efficient large scale relational data warehouse with SQL Server. Most large scale data warehouses use table and … Continue reading

What is ETL Mapping Document ?

In my travels I get questioned a lot regarding the importance of the ETL mapping document and do I have any good examples. Throughout my career I have developed many ETL mapping documents of various formats. I have taken a few minutes to outline the basics here. What is ETL Mapping Document :The ETL mapping … Continue reading