Project Online: SSIS package for OData delta sync

The sample SQL Server Integration Services (SSIS) package demonstrates how to perform a delta sync to reduce download times. The package retrieves Project Web App (PWA) data only for projects that changed since the last sync. This sample applies to Project Online reporting when report data is replicated to a local SQL Server database.

Note: This sample package is intended for demonstration only and should not be deployed to a production environment. Microsoft will not maintain or support this package. Use the package and the information in this article as guidance for building an SSIS package that fits your reporting needs.

Supported Operating Systems

Windows Server 2008 R2 Datacenter, Windows Server 2008 R2 Enterprise, Windows Server 2008 R2 SP1, Windows Server 2008 R2 Standard, Windows Server 2008 Service Pack 2, Windows Server 2012

• The DSTX file is an SQL Server Integration Services (SSIS) package. See the Project Online SSIS Delta Sync.pdf file for prerequisites and instructions about how to run the package.

1. Choose the Download button on this page to start the download.
• Choose Save or Save this program to disk to copy the download to your computer.
• Read the Project Online SSIS Delta Sync.pdf file for prerequisites and instructions about how to run the package. The file is an Adobe Reader file. Users who do not have Adobe Reader can download it from Adobe.