//
archives

SQL Server BI

This category contains 6 posts

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

SSIS with Informix\Oracle Oledb connection not working when a config file is included

I am running a SSIS package which has an Informix OLEDB Connection(32 bit). When I run from the Debug mode without the configuration file, the task completes successfully. But when I include the Informix OLEDB Connection in the config file and try to run the package, it fails with the following error. An OLE DB … Continue reading