In order to authenticate to Office 365, the machine must have the Share Point Server 2013 Client Components SDK installed on it.Once the client components are in place, and the option is selected, the data source should be able to connect to the source, and the connection manager can be closed.Last week, Microsoft released the OData Source for Microsoft SQL Server 2012 . It allows SQL Server Integration Services (SSIS) to use an OData feed as a first class citizen data source in the same manner as SQL Server, Oracle, etc.
Cannot browse network and find SBS server shared folder from Copier Setup SMB to shared folder Authenticate using admin user name and password Copier cannot connect. I have setup numerous copiers to scan to folder in a Windows Server 2003 environment. You may need to disable it on the SBS server if this is the case.
Lists are exposed as Collections, so if you want to work with list data, you can then select the list from the list of Collections.
At this point, the data source will act like any other SSIS data source, you can select and transform columns at will.
In the SSIS Toolbox, You should see the OData Source.
Drag the tool on to the design surface, and double click to configure it.