FAQ:SSIS:2012 Platform Deprecation

← SSIS:Data Quality Components

What should I do with my existing SSIS 2012 packages?

Existing SSIS 2012 packages can be migrated into your new SSIS 2014 + environment.

How do I upgrade my existing packages for SSIS 2014+?

To upgrade your existing SSIS 2012 to SSIS 2014 +, follow these steps:

1. Install Melissa’s SSIS components into your new environment.
2. Open the package using Visual Studio 2013 +.
3. Edit the Public Key Token value for each of Melissa’s SSIS components contained within the package.
   1. For instructions on how to obtain the new Public Key Token value for Melissa’s SSIS components and how to edit the Public Key Token value, visit our SSIS Wiki page: SSIS How to Update Public Key Token
   2. Once the new Public Key Token has been added to your package, you can then save the package. Your package has now been updated.
   3. Per Microsoft’s standards, each of Melissa’s SSIS components must contain a unique value for the Public Key Token for each platform.

What happens if my organization is not ready in time for the deprecation?

You will still be able to use Melissa’s SSIS 2012 platform. However, after the July 24th, 2023 deadline, Melissa’s SSIS 2012 platform components will remain static and will not receive any further updates regarding new fields or options added to the Melissa SSIS components. Also, support will be limited for Melissa’s SSIS 2012 platform. To maintain security in your environment and to stay up-to-date with Melissa’s latest SSIS component features, please migrate to a SQL Server 2014 + environment.

What does this mean for me?

If you currently use Melissa’s SSIS 2012 platform, which consists of Visual Studio 2010 and Microsoft SQL Server 2012, it is highly recommended to upgrade to a SSIS 2014 + environment. If you are currently using a SSIS 2014 + environment, then you are up-to-date and will not need to upgrade your environment.

Why are you doing this?

SQL Server 2012 will no longer receive security updates, non-security updates, bug fixes, or technical support after Microsoft ends support on July 12th, 2022. To maintain security and support for our clients, we believe it is best to deprecate Melissa’s SSIS 2012 platform.

Will any other of Melissa’s SSIS supported platforms be deprecated anytime soon?

Microsoft will end its extended support for SQL Server 2014 on July 9th, 2024. Melissa will then deprecate the SSIS 2014 platform. Existing clients will be notified of the SSIS 2014 deprecation event.

Can I expect the same features and updates from Melissa’s SSIS components when I upgrade to SQL Server 2014 +?

Yes, Melissa’s SSIS components are designed identically across all of our supported platforms. Deprecated SSIS platforms will no longer receive new features or updates and will remain static.

What about SSIS 2022? Will Melissa support the SSIS 2022 platform?

Microsoft has released Visual Studio 2022. However, the SQL Server Integration Service template for Visual Studio 2022 has not yet been released. Melissa plans on supporting SSIS 2022 in the near future, pending the release of SQL Server Integration Services from Microsoft. The latest SSIS news and updates will be posted on Melissa’s blog. Stay tuned.

For assistance on transitioning to another of Melissa’s officially supported SSIS platforms, please contact Melissa’s Tech Support: Tech@melissadata.com

Which officially supported SSIS platform does Melissa recommend?

Melissa recommends SSIS 2016 + platforms. While SSIS 2014 is supported by Melissa, we plan to deprecate the SSIS 2014 platform next, in early 2025. As Microsoft will also end support for SQL Server 2014 on July 9th, 2024.

What other officially supported platforms does Melissa plan on deprecating in the future?

Here is an official timeline of Melissa’s SSIS platform deprecation’s planned:

	1/1/2025	1/27/2025	7/26/2027	10/23/2028
SSIS 2012	Deprecated - Not Supported by Melissa	Deprecated - Not Supported by Melissa	Deprecated - Not Supported by Melissa	Deprecated - Not Supported by Melissa
SSIS 2014	Supported by Melissa	Deprecated - Not Supported by Melissa	Deprecated - Not Supported by Melissa	Deprecated - Not Supported by Melissa
SSIS 2016	Supported by Melissa	Supported by Melissa	Deprecated - Not Supported by Melissa	Deprecated - Not Supported by Melissa
SSIS 2017	Supported by Melissa	Supported by Melissa	Supported by Melissa	Deprecated - Not Supported by Melissa
SSIS 2019	Supported by Melissa	Supported by Melissa	Supported by Melissa	Supported by Melissa