Hi Folks,
We have a requirement to create a dedicated SSIS server and we are planning to create this on SQL 2016 version. We need to migrate all SSI projects from an existing SQL 2014 enterprise instance. All Projects have been developed on Visual Studio 2013/2015. Do you think there will be any issues migrating from SQL 2014 enterprise to SQL 2016 Standard edition. Should deploying individual projects or restoring SSISDB database and upgrading the SSISDB a best option here.
Also is there an option to check if SSIS packages are using any enterprise features?
Many thanks!