Martin Nguyen

paultran00

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
We are using SQL SERVER 2016 in the Microsoft Azure cloud. &nbsp;I have an existing ssis package that gets data from a sharepoint 2016 list.<br />
<br />
I’m using vs2017. &nbsp;The package runs fine on my workstation but not in the Microsoft Azure cloud.<br />
Cloud error log says: &nbsp;version 14 script is not supported.<br />
So I changed the ssis targetServerVersion from 2017 to 2014, and that error went away.<br />
<br />
But a new error appeared: odata source could not be upgraded to the newer version of the component. &nbsp;The performance upgrade failed.<br />
<br />
Note: the cloud does not show the OData source driver, the Azure cloud admin said use ‘sharepoint list adapter 2014’ driver.<br />
<br />
Question: &nbsp;should i get odata source working or replace how it gets data from a sharepoint list by using ‘sharepoint list adapter 2014’?<br />
Please provide an example how to deploy ‘sharepoint list adapter 2014’ in SSIS (Visual Studio 2017).<br />
<br />
thank you
</div>
</div>


Hi,

We are using SQL SERVER 2016 in the Microsoft Azure cloud.  I have an existing ssis package that gets data from a sharepoint 2016 list.

I’m using vs2017.  The package runs fine on my workstation but not in the Microsoft Azure cloud.
Cloud error log says:  version 14 script is not supported.
So I changed the ssis targetServerVersion from 2017 to 2014, and that error went away.

But a new error appeared: odata source could not be upgraded to the newer version of the component.  The performance upgrade failed.

Note: the cloud does not show the OData source driver, the Azure cloud admin said use ‘sharepoint list adapter 2014’ driver.

Question:  should i get odata source working or replace how it gets data from a sharepoint list by using ‘sharepoint list adapter 2014’?
Please provide an example how to deploy ‘sharepoint list adapter 2014’ in SSIS (Visual Studio 2017).

thank you

SSIS 2017, Azure Cloud 2016, sharepoint list adapter 2014

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft Azure is a cloud computing platform and infrastructure for building, deploying and managing applications and services through datacenters. It provides both platform-as-a-service (PaaS) and infrastructure-as-a-service (IaaS) services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems. Cloud Services is a PaaS environment and can be used to create scalable applications and services; there are specific software development kits (SDKs) provided by Microsoft for Python, Java, Node.js and .NET. Azure also has file and storage services, data management, analytics and DNS services.

Azure

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.