=Overview==Configuration - Essentials==Configuration - Advanced==Appendix===Options and Settings==<!--Explain all applicable misc options and settings that shouldn't be explained above here...-->===General Settings==={| class="wikitable"|-||Option||Description||Example|{ Banner-|||||||UnderConstruction }}
===Display Settings===
{| class="wikitable"
|-
||Option
||Description
||Example
|-
||
||
||
|}
=Examples=
<!--
Sample Image Format:
[[File:xmlSample.png|thumb|none|middle|500px|Example field configured as a budget sheet.]]
Sample Table Format:
{| class="wikitable"
| Option
| Description
| Example
|-
|
|
|
|}
Sample Syntax Format:
Empty space at start of line to highlight the row, italicize any variables that the user would fill in (as opposed to literal words that need to be used in syntax)
@section.''SectionNodeName''@
Sample Code Block:
When you want to write an example block of code, you should highlight it and also escape any special characters that might be construed as HTML formatting and outputted incorrectly by the Wiki by using a pre (pre-formatted text) tag
<pre>
<?xml version="1.0"?>
<Company>
<Name>Oranges Inc.</Name>
<Description>Peel.
Eat.
Repeat.</Description>
</Company>
<Company>
<Name>Bananas Ltd.</Name>
<Description>You're going to go "bananas" over our product!</Description>
</Company>
</pre>
Unordered list:
When listing information with bullet points in no order
* Point 1
* Point 2
* Point 3
Ordered list:
When listing information with numbers to denote ordered steps
# Step 1
# Step 2
# Step 3
=Overview=
An example on how to import SmartSimple OData Report into MS SQL Database using SQL Server Integration Services (SSIS).
[[Image:TranformDataDiagram.png|thumb|center|1000x400px]]
=Configuration - Essentials=
# SQL Server
# Visual Studio 2015/2017
# SQL Server Integration Services (SSIS) VS2015/2017 add-on
Sample Page Header Banners:=Creating a new SSIS Package===A simple SSIS package==Deprecated Feature# Open Visual Studio<span class=# 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 "mceNonEditable templateData Flow" id=work surface# Select "bs_template:@@@TPL0@@@OData Source" data-bs-name=and drag to the work surface# Double click "DeprecatedOData Source" data-bs-type=, OData Source Editor appears## Click "templateNew" data-bs-id=, a new window "0OData Connection Manager Editor">{{ Deprecated }}</span>opensDeprecated Page## Enter the URL of the OData, username, password<span class=## Click "mceNonEditable templateTest Connection" id=to test## Press "bs_template:@@@TPL1@@@OK" data-bs-name=## "DeprecatedPageOData Connection Manager Editor" data-bs-type=closes## Choose the desired collection## Click "templatePreview" , a new window will pop up to show data-bs-id=from the collection## Click "1Columns">{{ DeprecatedPage }}</span>Professional Services## Choose the column headers you want to transfer to MSSQL<span class=## Press "mceNonEditable templateOK" id=# Select "bs_template:@@@TPL2@@@Destination Assistant" data-bs-name=to set up SQL Server Connection# Double click "Banner-BillableDestination Assistant" data-bs-type=, "templateOLE DB Destination Editor" data-bs-id="2">{{ Banner-Billable }}</span>appearsPage Under Construction# Select the SQL Server to import OData to<span class=# Connect "mceNonEditable templateOData Source" id=and "bs_template:@@@TPL3@@@OLE DB Destination" data-bs-name=# Double click "Banner-UnderConstructionOLE DB Destricaiton" data-bs-type=to edit metadata if necessary, then press "templateOK" data-bs-id=# Press "3Start">{{ Banner-UnderConstruction }}</span>to run the package# When process is complete, it will show you how many rews were imported to MSSQL database
-->=Deploying SSIS Package==Scheduling SSIS Package==See Also=* [[Reports]]* [[Odata Overview|OData Overview]]* [[OData Connector]]* [[SmartSimple OData Feed to Excel]]