SmartSimple OData Feed to SQL Server Database

From SmartWiki
Revision as of 13:08, 7 June 2018 by Lalaine Songalia (talk | contribs) (Configuration - Essentials)

Jump to: navigation, search

Overview

An example on how to import SmartSimple OData Report into MS SQL Database using SQL Server Integration Services (SSIS).

TranformDataDiagram.png

Configuration - Essentials

  1. SQL Server
  2. Visual Studio 2015/2017
  3. SQL Server Integration Services (SSIS) VS2015/2017 add-on

Creating a new SSIS Package

Deploying SSIS Package

Scheduling SSIS Package

See Also