This video will demonstrate how to connect or integrate SharePoint in SSIS package using OData.
http://pragmaticworks.com/Products/Task-Factory/Feature/Connectivity/SSIS-Rest-Source This video gives an overview of the SSIS Rest Source that gives you the ability to pull data from any rest enabled web service into your data flow in SSIS.
How to connect to an OData datasource using SharePoint Online and Business Connectivity Services using BCS Meta Man. www.lightningtools.com
Microsoft SSIS was low on new features in a couple of releases and now it is catching up really quickly - and we want you to catch up with us and Microsoft. There were a lot of new features in 2016 and 2017, and they include connectivity, OS, operating on big data, and many many more. We will be covering selective new features such as how to operate an Azure blobs, do AlwaysOnEncryption, updating Odata in our session SSIS 2016/2017 Intermediate Virginia Mushkatblat has 20 years of development and architectural experience with critical data-intensive applications. She has worked in companies ranging from start-ups to international conglomerates with the range of requirements, including those of 24/7 and batch processing, and lead teams of DB developers, architects and administrators. She has worked in entertainment, technology, e-commerce, and financial industries. She holds Masters Degrees in Engineering and in Computer Science and originated several patents.
If you're unfamiliar with it, SSIS can initially seem intimidating. A quick start approach can get you up and running - without the 700-page manual. See how practical data migration, beyond what you could accomplish using the Microsoft Dynamics CRM Data Import Wizard, can be accomplished quickly with the right guide and tools from SQL Server SSIS. More Microsoft Dynamics CRM Webcasts: http://msdynamicsworld.com/webcasts
Learn how to Read JSON Data in SSIS from RESTful Web Service or JSON Files. For more info: http://zappysys.com/products/ssis-powerpack/ssis-json-file-source/ Features ◾Bulk extract/output JSON data from File ◾Bulk extract/output JSON data from Web Service Url (with OData REST API Support) ◾Support for reading JSON string or file/url path from SSIS Variable ◾Support for JSONPath expression ◾Support for looping through multiple files using wild card pattern (e.g. *.json). ◾Support for HTTP Request with Custom Headers (Useful when JSON is coming from REST API services where you supply credentials or API Key). ◾Support for very large JSON files ◾Support for SQL Server 2005, 2008, 2012, 2014 (32 bit and 64 bit)
Native JSON support in SQL Server 2016 CTP My blog link for SQL Scripts: http://sqlwithmanoj.com/2015/06/01/exportconvert-table-or-sql-query-data-to-json-string-format-sql-server-2016-part-1/ - Export SQL Tables or Queries to JSON Strings with "FOR JSON AUTO/PATH" option For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Sharepoint Connection in SSIS