Move the scripts to a new Script task.", and "Type '.ScriptTask.SSISScriptTaskEntryPointAttribute' is not defined." Errors would show up such as "'Dts' is not a member of 'Microsoft.SQLServer'", "Type '.ScriptTask.VSTARTScriptObjectModelBase' is not defined", "Failed to migrate scripts contained in the package to the VSTA 14.0 format.
![does sql server 2017 developer edition have ssis does sql server 2017 developer edition have ssis](https://sqlkover.com/wp-content/uploads/2019/04/image-15-1024x354.png)
Net Framework version as it always revertsīack to original settings in the script task properties However, once changing the target version to SQL Server 2017 within SSDT, there are some things that showed up that SSDT did not catch/fix or could not handle for some reason. I figured things would be the same with the latest SSIS and SSDT versions. Once they introduced the ability to target some previous versions of SSIS, that feature seemed to work as expected. In previous SSDT changes, one release worked for a particular version of SSIS.
Does sql server 2017 developer edition have ssis upgrade#
So as part of normal upgrade routine, decided to open an SSIS package and upgrade it like before with the previous SSDT changes. SQL Servers with SSIS installed that were upgraded to 2016 or 2017 seemed to have no issues with packages that were in MSDB or the package store since the jobs continued to run as expected post-upgrade.
![does sql server 2017 developer edition have ssis does sql server 2017 developer edition have ssis](https://www.dirceuresende.com/wp-content/uploads/2018/06/SQL-Server-Express-e-Developer-Até-onde-podemos-usar-as-versões-gratuitas-do-SQL-Server-1.png)
Even now when the package was upgraded to SSDT and targeting SQL Server 2016 everything still worked as it always has in addition to being able to take advantage of the latest SSIS features (package parts, project parameters, etc.) and deploying the package through SSDT/Visual Studio to the same target SQL Server. The purpose of this question is to document my answer to what seemed to be a strange issue when changing the target SQL Server version of an SSIS package created in some older versions of SSIS prior to 2012 that use script tasks.Īn SSIS package originally created in BIDS 2005 or 2008 had no issues when upgraded through the various versions of BIDS/SSDT over the years.