question

SQLDBA123 avatar image
SQLDBA123 asked

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?

sql server 2008 r2sql server 2017sql-server 2017
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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

KenJ avatar image KenJ commented ·

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.

0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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