Question by SQLDBA123 · Mar 08, 2019 at 03:34 PM · sql server 2008 r2 sql server 2017 sql-server 2017

To migrate Legacy DTS packages which are on SQL Server 2008 R2 to SQL Server 2017

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?

0 Show 1

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ · Mar 09, 2019 at 01:16 AM 0

Share

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.

Copyright 2019 Redgate Software. Privacy Policy