Execute legacy SSIS packages on newer SQL version

Posted by: tiki.emerita0k on 3 November 2022, 9:23 pm EST

  • Posted 3 November 2022, 9:23 pm EST

    I have a few SSIS packages, developed in SQL Server 2008. Those packages have ActiveX Script Task. When I try to open those packages in VS 2017, it throws an error, saying ActiveX task is deprecated. Converting those task to Script Task would be really time consuming.

    Is there a way to execute those packages in SQL Server Agent? We use SQL Server 2016 Standard edition.

    I tried executing from the file system, but it also throws an error:

    The “Microsoft.SqlServer.Dts.Tasks.ActiveXScriptTask.ActiveXScriptTask, Microsoft.SqlServer.ActiveXScriptTask, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91” task has been deprecated and cannot be used with this version of Integration Services.

    I don’t really need for now to upgrade those packages, I can still use Business Intelligence 2008 to maintain them. I just need them to run on the SQL Server 2016 instance.

    Thanks for your time and help

  • Posted 10 April 2023, 8:44 pm EST

    Open a new Solution in Visual Studio.

    Open the project properties and select an SQL server as “Deployment Target Version”: …

    Save the project.

    Add the SSIS packages to the project.

    Save the project again.

    Change the “Deployment Target Version” to SQL Server 2019.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels