An example on how to pull to import SmartSimple OData Report into MS SQL Database using SQL Server Integration Services (SSIS).[[Image:TranformDataDiagram.png|thumb|center|900x280px|<strong>Diagram</strong>1000x400px]]
=Configuration - Essentials=
# SQL Server
# Visual Studio 2015/2017
# SQL Server Integration Services (SSIS) VS2015/2017 add-on
=Creating a new SSIS Package=
==A simple SSIS package==
# Open Visual Studio
# Create a new Integration Service Project
# Save the new project into the desired folder
# Drag a dataflow task to the working surface
# Double click "Data Flow" to bring up the new "Data Flow" work surface
# Select "OData Source" and drag to the work surface