The operation has timed out when connecting to OData by using SSIS in Project Online

Symptoms

When you use Microsoft SQL Server Integration Services (SSIS) packages to download data from your Project Online OData feeds, you receive the following error message:

The operation has timed out.

Status

We are currently investigating the issue.

Workaround

To work around this issue, edit the .NET Framework Machine.config files to increase the number of allowed connections to Microsoft SharePoint and Project Online on the server that your SSIS package is configured to run. To do this, follow these steps:

1. Edit the following files on the server that's running the SSIS package:

   %windir%\Microsoft.NET\Framework\<version>\config\machine.config

   %windir%\Microsoft.NET\Framework64\<version>\config\machine.config

   Note

   For the <version> folder placeholder, the correct value is typically the most recent version of the .NET Framework, such as 4.0.xxxxx. However, if you have configured your SSIS package to use a different .NET Framework version, update this value accordingly.

   

2. Make a copy of both Machine.config files as a Backup.

3. Open each Machine.config file, and scroll all to way to the bottom of the file. At the very end of the file, add a space between the </system.web> and </configuration> tags, and then paste the following snippet:

    <system.net>
    <connectionManagement>
    <add address = "https://contoso.sharepoint.com" maxconnection = "30" />
    </connectionManagement>
    </system.net>
   

   Note

   • You must replace the address with your SharePoint domain. For example, if your PWA site is https://contoso.sharepoint.com/sites/pwa, the address should be https://contoso.sharepoint.com.

   • Consider increasing or decreasing the maxconnection value in this step, depending on how your SSIS package is configured. For example, if you have a larger number of feeds that you're pulling concurrently, you may need a larger number of connections. For only a few feeds, you can use a smaller value. For more information about the .NET Framework Connection Management setting, see <add> Element for connectionManagement (Network Settings).

   • After you're done adding the snippet, the edited file should resemble the following:

     

4. Save the changes, and then close the file.

5. Make sure that the edit is done on both Machine.config files that are listed in step 1.

6. To make sure that the setting takes effect, you can either stop and restart the application that the SSIS package runs under, such as SQLAgent, or restart the server.