How to copy SSIS packages from sqlserver 2008R2 to 2016

Avyayah 1,211 Reputation points
2021-05-13T11:05:31.367+00:00

Will a simple copy from one sqlserver to another sqlserver complete the process?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,236 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Tom Phillips 17,706 Reputation points
    2021-05-13T13:25:05.513+00:00

    You are better off redeploying the SSIS code, rather than trying to "copy" them from one server to another.


  2. Cris Zhan-MSFT 6,601 Reputation points
    2021-05-14T07:21:18.983+00:00