can we create an SSIS schedule on a standard SQL server, since i am facing an error says:
cannot run on the installed edition of Integration Services. It requires Enterprise Edition or higher.
can we create an SSIS schedule on a standard SQL server, since i am facing an error says:
cannot run on the installed edition of Integration Services. It requires Enterprise Edition or higher.
Hello,
What is the purpose of your SSIS package ?
Can you tell us the version of SQL Server do you have and also the version of the tool that you use to create it ?
Hi IgnaNoto-8989:
The packages to retrieve data from Oracle DB into another Oracle DB,
I am using oracle connector MicrosoftSSISOracleConnectorX64 and MicrosoftSSISOracleConnectorX86
SQL Server version is:
Microsoft SQL Server 2019 (RTM-CU9) (KB5000642) - 15.0.4102.2 (X64) Jan 25 2021 20:16:12 Copyright (C) 2019 Microsoft Corporation Standard Edition (64-bit) on Windows server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor)
Visual Studio (SSDT) : 2017
Services and tools:
Microsoft SQL Server Data Tools for Visual Studio 2017
Version 15.9.37
VisualStudio.15.Release/15.9.37+28307.1585
Microsoft .NET Framework
Version 4.7.03062
Installed Version: IDE Standard
ProjectServicesPackage Extension 1.0
ProjectServicesPackage Visual Studio Extension Detailed Info
SQL Server Data Tools 15.1.62002.01090
Microsoft SQL Server Data Tools
SQL Server Integration Services 15.0.2000.68
Microsoft SQL Server Integration Services Designer
Version 15.0.2000.68
Could you please have a check if you used the High-performance Oracle source and destination by Attunity or Data mining query transformation and so on?
This topic provides details about the features of SQL Server Integration Services (SSIS) supported by the different editions of SQL Server.
You may take a reference here integration-services-features-supported-by-the-editions-of-sql-server to see if you are using those unsupported component in your SSIS package which caused the issue in standard SQL server.
Regards,
Zoe
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)
Hi Zoehui-MSFT;
Yes, I have already checked this link and I am using the Oracle connector (MicrosoftSSISOracleConnectorX64 and MicrosoftSSISOracleConnectorX86). it runs with no issues but when I try to create a schedule it doesn't work. and the error shown.
Microsoft Connector for Oracle does not support the version lower than 15.0.4003.23 in SQL Server 2019. Please installed the latest CU patch for SQL Server 2019 in order to use Microsoft Connector for Oracle. Link for SQL Server 2019 CU1.
Check details here.
18 people are following this question.