Technical: Microsoft – SQL Server – v2008/R2 – Business Intelligence Studio – Cube Browsing – Error dragging measures\attributes to view pane

Background When Browsing Cube, one of the errors one might encounter as you add measures and attributes to the pane is one that reads: Retrieving the COM class factory for component with CLSID {C966837E-970C-4F4F-A91D-D81E21ABBBDB} failed due to the following error: 80040154. (Microsoft Visual Studio) Full Error Message Error Text =================================== Retrieving the COM class factory … Continue reading Technical: Microsoft – SQL Server – v2008/R2 – Business Intelligence Studio – Cube Browsing – Error dragging measures\attributes to view pane

Microsoft – SQL Server – Integration Services – Designer – Derived Column

Microsoft - SQL Server - Integration Services - Designer - Derived Column IsNull Checks whether a column is null, if so replaces it with something more ammenable Sample ISNULL(hrs_client_dob) ? (DT_DBTIMESTAMP)"1753-01-01 00:00:00.000" hrs_client_dob   (SQLServerCentral.com forum <manmaria> --> http://www.tek-tips.com/viewthread.cfm?qid=1283075&page=1)