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=220.127.116.11, 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