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?
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?
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.
19 People are following this question.