This video will demonstrate how to connect or integrate SharePoint in SSIS package using OData.
See how to upload files and their metadata to SharePoint using SSIS with Task Factory. Download a trial of Task Factory here: http://www.taskfactory.com.
In this video we will look into exporting data out of SQL Server 2016 in JSON using BCP and FOR JSON PATH and importing the data into MongoDB using mongoImport shell
This Session is not divided into separate parts and should be watch in its entirety because of the strong dependency between each concept that is presented. This video presents concepts from the following outline: Server Environments On Premise SQL Server (source) Azure VM SQL Server (target Projects Create Project SSISDB Folder Deploy Packages from Visual Studio Environments Script Add Reference to Project Map Project Parameters to Environment Variables Create Service Account Assign to local databases Assign Permission and roles in local database Logins and Permission to External Data Sources Create Credential Create SQL Agent Proxy SQL Agent Jobs Create Script Modify Script Test and Debug
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
uso de JSON en SQL Server 2016
Sharepoint Connection in SSIS
This video shows a quick way to use the Web Service Task in SSIS, and how to load the data into SQL Server. Website Link: http://holidaywebservice.com/HolidayService_v2/HolidayService2.asmx? XSLT Converter Code: https://pastebin.com/D5vzBNPN Also I recommend XML Notepad to get a good understanding of XML structure if you are new to XML or like a clean UI better than just code. XML Notepad: https://www.microsoft.com/en-us/download/details.aspx?id=7973
How to connect to an OData datasource using SharePoint Online and Business Connectivity Services using BCS Meta Man. www.lightningtools.com
Use SSIS to parse JSON. No custom components are used. Find out more at http://www.bi-accelerate.com