//
archives

SQL Server BI

This category contains 7 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

FREE tools for SSAS Developers

  I am always searching for tools to assist in helping me work more efficiently. I have built many myself, however why build if you can buy (cheaply) and why buy if you can find something free. Additionally many times I will find some code to use as a base for something I need or … 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

SSIS: OleDB Data source: cannot retrieve the column code page info from the OLE DB provider

  When i tried to set an Informix data source in a SSIS package, the following warning was shown when the clicked preview button. Warning at {Local Component ID} [OLE DB Source [1]]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the “DefaultCodePage” property, the code page … Continue reading