Difference between revisions of "SmartSimple OData Feed to SQL Server Database"

From SmartWiki
Jump to: navigation, search
(→‎Configuration - Essentials)
Line 4: Line 4:
  
 
=Configuration - Essentials=
 
=Configuration - Essentials=
 +
# SQL Server
 +
# Visual Studio 2015/2017
 +
# SQL Server Integration Services (SSIS) VS2015/2017 add-on
  
 
=Creating a new SSIS Package=
 
=Creating a new SSIS Package=

Revision as of 13:08, 7 June 2018

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

Retrieved from ‘https://wiki.smartsimple.com/index.php?title=SmartSimple_OData_Feed_to_SQL_Server_Database&oldid=32116’