Upgrading an SSIS package to a newer version of SQL Server:

SSIS packages created using SQL Server (2005-2017) cannot be automatically upgraded to a later version without first performing a pre-upgrade step. First, open the .dtsx package file in a text editor such as Notepad. Next, replace all instances of (if created using SQL Server 2005), (2008), or (2012), or (2014) with either (if upgrading to SQL Server 2008), (2012), or (2014), or (2016), (2017), (2019) then save the modified file. Lastly, open the solution with BIDS (2008) or SQL Server Data Tools (2012/2017/2019), which will automatically convert the solution and package.

Note that as of SQL Server 2014-2017, SQL Server Data Tools must be downloaded and installed separately; please refer to: https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15 

For SQL Server 2019, please see this article Adding Data Tools/Integration Services to Visual Studio 2019 

*2019 requires mSQL version or newer

If you need to downgrade a project - then please click here

Was this article helpful?
1 out of 1 found this helpful

have a question or not finding what you're looking for?

Submit a ticket to get some help