Share via

SSIS package doesn't run in Microsoft Task scheduler

Ali Ahad 131 Reputation points
2021-07-25T19:02:41.007+00:00

I created a package that suppose to run at 3 AM every day, the package runs fine when I run it manually and loads the data but when I try to run via task scheduler I got a error message:

Description: There was an exception while loading Script Task from XML: System.Exception: The Script Task "ST_7981d5b42581467a996c7dcd4c02c280" uses version14.0 script that is not supported in this release of Integration Services. To run the package, use the Script Task to create a new VSTA script. In most cases, scripts are converted automatically to use a supported version, when you open a SQL Server Integration Services package in %SQL_PRODUCT_SHORT_NAME% Integration Services.at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask.LoadFromXML(XmlElementelemProj, IDTSInfoEvents events)

End Error

I have recreated the script task but error message is there.

SQL Server version:
Microsoft SQL Server 2014 (SP2-CU9) (KB4055557) - 12.0.5563.0 (X64) Dec 7 2017 01:00:06 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

Microsoft Visual Studio 2015 Shell (Integrated)
Version 14.0.25420.01 Update 3
Microsoft .NET Framework
Version 4.8.03761

Installed Version: IDE Standard

Microsoft Visual Studio Tools for Applications 2015 00322-10000-00000-AA935
Microsoft Visual Studio Tools for Applications 2015

Visual Basic 2015 00322-10000-00000-AA935
Microsoft Visual Basic 2015

Visual C# 2015 00322-10000-00000-AA935
Microsoft Visual C# 2015

COZYROC SSIS+ 1.0
Additional features for SSIS solutions

For more information about COZYROC SSIS+, see the website at
http://www.cozyroc.com
For customer support, call 1-919-249-7421.
Copyright (c) 2006-2018 COZYROC LLC

JavaScript Language Service 2.0
JavaScript Language Service

JavaScript Project System 2.0
JavaScript Project System

SQL Server Analysis Services 13.0.1400.361
Microsoft SQL Server Analysis Services Designer
Version 13.0.1400.361

SQL Server Data Tools 14.0.60519.0
Microsoft SQL Server Data Tools

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,578 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 36,586 Reputation points
    2021-07-26T01:50:05.01+00:00

    Hi @Ali Ahad ,

    Have you installed the newest SSDT for VS2015?

    You may refer this to have a check.

    And then Right click project > Properties > Configuration Properties > General > TargetServerVersion - Update to SQL Server 2014 > Redeploy.

    In addition, SSMS 17.x has issue related to SSIS deployment, try with SSMS 16.x or 18.x .

    Regards，

    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    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.
    Hot issues October

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ali Ahad 131 Reputation points
    2021-07-26T02:26:23.73+00:00

    Hi Zoe,

    It looks like changing the configuration properties did the trick. I will check it again tomorrow morning and see if task schedule kicks the job and data get loaded.

    Thanks,
    Ali.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.