#ProjectServer and #SharePoint 2010 / 2013 August 2014 Cumulative Update #PS2010 #SP2010 #PS2013 #SP2013 #MSProject

August 13, 2014 at 9:34 am | Posted in Administration, Configuration, CU, Fixes, Functionality, Information | Leave a comment
Tags: , , , , , , ,

The Office 2013 August 2014 Cumulative Updates are now available, please see the links below:

http://support.microsoft.com/kb/2989078

Project Server 2013 August 2014 Server Roll up package:
**** No Project Server 2013 server roll up packages for August 2014 ***

Project Server 2013 August 2014 CU:
http://support.microsoft.com/kb/2883083

Project 2013 August 2014 CU:
http://support.microsoft.com/kb/2883080

Also worth noting, if you haven’t done so already, install the March 2013 Public update: http://support.microsoft.com/kb/2768001 if installing the August 2014 CU.

The Office 2010 August 2014 Cumulative Updates are now available, please see the links below:

http://support.microsoft.com/kb/2987238

Project Server 2010 August 2014 Server Roll up package:
**** No Project Server 2010 packages for August 2014 ***

Project Server 2010 August 2014 CU:
**** No Project Server 2010 packages for August 2014 ***

Project 2010 August 2014 CU:
http://support.microsoft.com/kb/2883021
Remember SP1 or SP2 is a pre-requisite for the Office 2010 August 2014 CUs.

As always, test these updates on a replica test environment before deploying to production.

#ProjectOnline data via #ODATA and #SSIS in #SQL database table delta sync example #BI #Office365

August 11, 2014 at 6:49 pm | Posted in Add-on, Administration, Configuration, Customisation, Functionality, Information, T-SQL | Leave a comment
Tags: , , , , , , , ,

Microsoft recently released some great documentation and an example SSIS package on only pulling down the changes from Project Online to your custom SQL database – this will improve the efficiency of your Project Online SSIS packages. I recommend you take a look if you haven’t already:

http://msdn.microsoft.com/en-us/library/office/dn794163(v=office.15).aspx

http://www.microsoft.com/en-us/download/details.aspx?id=43736

For a walkthrough of an example SSIS package for Project Online see:

https://pwmather.wordpress.com/2014/03/26/projectonline-data-via-odata-and-ssis-in-sql-database-table-on-premise-msproject-sharepointonline-bi-ssrs-office365-cloud/

Or a great example from Martin here:

http://nearbaseline.com/blog/2014/04/project-site-custom-list-reporting-using-ssis-odata-connector/

Create a free website or blog at WordPress.com.
Entries and comments feeds.