question

AhmedMahameed-1533 avatar image
0 Votes"
AhmedMahameed-1533 asked ZoeHui-MSFT commented

SSIS schedule

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.


sql-server-generalsql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

IgnaNoto-8989 avatar image
0 Votes"
IgnaNoto-8989 answered AhmedMahameed-1533 commented

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 ?

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·
ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT commented

Hi @AhmedMahameed-1533,

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.




· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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. :)

0 Votes 0 ·

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.

0 Votes 0 ·
ZoeHui-MSFT avatar image ZoeHui-MSFT AhmedMahameed-1533 ·

Hi @AhmedMahameed-1533,

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.


0 Votes 0 ·