Tag: SQL Server Integration Services

SCOM (Systems Center Operations Manager) Cube and Data warehouse

What I have done is I have found that it is very handy having all our SCOM data in a data warehouse and then having it in a SSAS (SQL Server Analysis Services). Within the zip file which can be located here below it has all the details for the following: ·         SCOM Data Warehouse and OLAP Documentation.docx o   This…

Data warehousing – Bringing down data twice but avoiding deleting on the data warehouse Fact Table

This is better explained with our example below.   Example: ·         We had a situation where we were getting data down, but due to the nature of the data we were getting is we were missing data. ·         Also another note was the fact that we did not store the granular data, but aggregated the data, so due to this…

SSIS – Stopping an Error from Propagating to its Parent (Enabling an SSIS Package to continue when an error happens)

Due to our environment and packages we create, we have to enable the packages to continue even if it fails for some reason (Cannot connect to a Server for example) so that the rest of the data will be captured. In the past we configured the MaximumError count to be 100, but this is not ideal, because if another component…