Explore LABS


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-2019, 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 

If you experience an error related to tasks not being registered for use on the PC when attempting to open the tasks, please check that the TargetServerVersion in the SSIS package is set correctly relevant to the version of SQL Server you are using.

*2019 requires mSQL version or newer

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

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


Please sign in to leave a comment.