SSIS – Configuring SSIS Package to run job after data loading has completed
In our example below, we are going to be using a SharePoint 2013 Data Alert job which was created in SQL Server Agent, and then insert this into an existing SSIS Project. The reason for doing this, is so that every time our SSIS Project runs, as part of the process, it can then fire off a SQL Server Job….
For SQL Server 2014 – Use the following link below to use an oData Source to get data from SharePoint List into your table
Below are the steps if you want to use SQL Server 2014 to get data from a SharePoint list into your database. The URL below explains how to download and install the OData Source for SQL Server 1. Click on the following link below a. http://www.microsoft.com/en-us/download/details.aspx?id=42295 2. Then once you load the page click on Download a. This will then…
Sharepoint 2013 – refreshing excel workbook with direct connection to sql server analysis services (SSAS) cube
I have not blogged in a while, due to moving countries and starting a new job. So i do hope that this blog will help someone or let them know how easy it is to use SharePoint 2013 to refresh data in an Excel spreadsheet. What I needed to do, was to use an existing Excel spreadsheet which connected directly…
Framework for Automating SQL Server Reporting Services (SSRS) data driven subscriptions – Part 1
Description: What the goal was to find a way to automate how an end user could subscribe to a SSRS Data Driven Subscription without any intervention from the Business Intelligence Developer. And also enable the end users to have their own selections. And finally if they did not want to receive the report any longer to then delete their subscription….
SharePoint 2013 – Creating a data source to an SQL Server Analysis Services (SSAS) OLAP Cube
Below are the details when using SharePoint 2013 when you want to collect to an SQL Server Analysis Services (SSAS) OLAP cube, instead of only being able to use the SSAS Tabular. Example: · In our example we are going to connect to our Adventure Works DW 2012 SSAS 1. Go into your SharePoint 2013 website and then…