Setting up prerequisities for SSIS package to retrieve data from an excel workbook hosted on SharePoint Site or any WebDAV Share

Scenario Let’s assume you run into a requirement for extracting data from an Excel workbook hosted on a SharePoint URL using an SSIS package. It may be a bit tricky to implement if you aren’t aware of the prerequisites needed to get this package running successfully. Background When an excel workbook or any document is hosted…

2

Proactive Caching – List all Objects in your SSAS Server using it

Hello All, Like every problem that follows with a solution, today I am going to present a SSAS problem in hand and resources for you to solve it : Prerequisite information What is Proactive Caching? Refer : http://technet.microsoft.com/en-us/library/ms174769(v=sql.110).aspx Taking an extract out of the above article : “Proactive caching provides automatic MOLAP cache creation and management for OLAP objects. The…

0