Tuesday, 5 July 2016

Using the SSIS OData Source Connector with SharePoint Online

Error SS : Using the SSIS OData Source Connector with SharePoint Online

Once you install the OData Source, you open up SQL Server Data Tools, open an SSIS project, and add or edit a data flow task. In the SSIS Toolbox, You should see the OData Source.

Drag the tool on to the design surface, and double click to configure it. You’ll first need to configure an OData Connection Manager, and you’ll do that by clicking the new button.
Give the connection a name. The connection will be common to all lists and libraries within a site, so something based on the name of the site is likely appropriate.

If you are using Office 365, and you click Test Connection at this point, you’ll receive an error “Test connection failed –> the remote server returned an error: (400) Bad Request.”
This is due to Office 365’s “unique” authentication mechanism. In order to authenticate to Office 365, you must first select the “All” button in the toolbar, and set the value of “Microsoft Online Services Authentication” to true.
Once you have change option for Microsoft online services Authentication False to True.
Then try to connect again, Click on test connection and see the result

Hope this help you.


  1. I'm getting 403 forbidden error. Please help.

  2. Im getting Test connection failed -> The remote server returned an error: (400) Bad Request.

  3. Hi My issue is that I cannot find “Microsoft Online Services Authentication” in my SharePoint Online version. I can only see Authentication Type; Domain; Password; User ID.

    Please can you suggest on any thing I could do?


  4. The effectiveness of IEEE Project Domains depends very much on the situation in which they are applied. In order to further improve IEEE Final Year Project Domains practices we need to explicitly describe and utilise our knowledge about software domains of software engineering Final Year Project Domains for CSE technologies. This paper suggests a modelling formalism for supporting systematic reuse of software engineering technologies during planning of software projects and improvement programmes in Final Year Project Centers in Chennai.

    Software management seeks for decision support to identify technologies like JavaScript that meet best the goals and characteristics of a software project or improvement programme. JavaScript Training in Chennai Accessible experiences and repositories that effectively guide that technology selection are still lacking.

    Aim of technology domain analysis is to describe the class of context situations (e.g., kinds of JavaScript software projects) in which a software engineering technology JavaScript Training in Chennai can be applied successfully