Requirement: Long back migrated SQL Server 2000 DTS packages to SQL server 2008 R2. Now new requirement, to migrate Legacy DTS packages which are on SQL Server 2008 R2 to SQL Server 2017.
Question: Is it possible? Is there any documentation steps?
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
you'll have to rewrite the DTS packages as SSIS packages. the backward compatibility components that allow the DTS packages to run in SQL Server 2008 are not available in newer versions.
Answers Answers and Comments
19 People are following this question.
Collation SQL Server 2017
SQL migration from 2008 R2 to 2017 always on
2000ms disk response time suddenly when reorganizing indexes
Date output format in SSMS 2014 AND 2017 as Oct 26 2018
SQL Server 2017 - logmarkhistory table empty