We are migrating some packages from sql server 2008 to 2016. But the ActiveX script task isn't loading correctly. I am very new with this tools. I would like to know how to update this kind of task.
Thanks in advance
The ActiveX Script Task has been dropped in SSIS 2012.
You have to rewrite a similar logic using some SSIS Tasks (file system, for loop ...) or you can create a DLL that contains the script and use it within the Script Task.
In addition, based on Discontinued Database Engine Functionality in SQL Server 2016 article
ActiveX subsytem is discontinued. Use command line or PowerShell scripts instead.
References