Execute legacy SSIS packages on newer SQL version

Execute legacy SSIS packages on newer SQL version

Posted by: tiki.emerita0k on 4 November 2022, 6:23 am EST

• 

  tiki.emerita0k

  • Post Options:
  • Link
    Copy

  Posted 4 November 2022, 6:23 am 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=12.0.0.0, 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

• 

  jimmy.wick90

  • Post Options:
  • Link
    Copy

  Posted 11 April 2023, 5:44 am 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.