Recently I was on a call with a client and one of their IT guys asked if the Microsoft Business Intelligence stack can do everything Exclesius can do. In short, the answer is sorta. Through reporting services the MS BI stack can provide similar functionality however, it cannot provide the flash animations you get in…
Just had some ideas from class tonight regarding Earned Value Analysis (EVA). If you’re unfamiliar with EVA google it and you’ll find it is basically a way to measure a projects performance. Microsoft has a small ‘about’ page found here that might help as well – office.microsoft.com/en-us/project/HP010342581033.aspx The three key elements of EVA are: Budgeted…
Thanks to “jaegd” for his post here: forums.microsoft.com/… on how to accomplish this. Below please find some more details along w/ a example which can be downloaded here (ssis-2005-excel-2007-source-example). Steps Create new OLEDB Connection by right clicking on the Connection Manager tray Chose any valid type or value for the connection and click okay Rename the…
Recently I was having some issues getting a new SQL Server Analysis Services (SSAS) cube to process on a new development (dev) server. The error I kept receiving was…
Sometimes files are received such as client feeds that contain values in columns that exceed the maximum number of characters allowed in the destination database. When these records are imported an error occurs when trying to fit this value into the column with the character limitation. In these cases it is helpful to have a…
Customized Reading of Excel Sources in SQL Server 2005 Integration Services
Where’d the old site go?