将SQL Server 2008 R2上的旧版DTS包迁移到SQL Server 2017?
问题描述:
要求:长期迁移SQL Server 2000 DTS包到SQL Server 2008 R2现在新要求,将SQL Server 2008 R2上的旧版DTS包迁移到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?
答
您好SQLDBA321,
Hi SQLDBA321,
超越SQL Server 2008 R2 DTS没有任何支持。
Beyond SQL Server 2008 R2 DTS is out of any kind of support.
我能看到的唯一解决方案是在SSIS中重写DTS包。
The only solution I can see is to rewrite the DTS packages in SSIS.