Microsoft Download Center Archive
 | Project Online: SSIS package for OData delta sync |
Download a sample SQL Server Integration Services (SSIS) package that performs a delta sync to update Project Web App (PWA) data for Project Online reporting.
- 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.
Files
 | Status: LiveThis download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center. |
| File | Size |
|---|---|
 OData.AssignmentsTimephased.zipSHA1: 4676aa34a7d5031984dda70e560a7535dcc55451 | 26 KB |
 Project_Online_SSIS_Delta_Sync.pdfSHA1: 945079f69bb980f09fffbcd90a3b42364ba2fa44 | 531 KB |
File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.
System Requirements
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.
Installation Instructions
- 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.