在 SQL Server 2012 上运行 DTS 包 [英] Running DTS packages on SQL Server 2012

问题描述

我了解到 SQL Server 2012 不支持 DTS 包.我知道有一个向后兼容包/选项，我们用于 SQL Server 2008R2 来运行 DTS 包.该向后兼容包对 SQL Server 2012 不起作用吗?

I read that DTS packages aren't supported in SQL Server 2012. I know there's a Backward Compatibility package/option out there that we used for SQL Server 2008R2 to run DTS packages. Will that Backwards compatibility package not work for SQL Server 2012?

对于 2008 R2http://msdn.microsoft.com/en-us/library/bb500440(v=sql.105).aspx

For 2008 R2 http://msdn.microsoft.com/en-us/library/bb500440(v=sql.105).aspx

推荐答案

作为文档 说，SQL Server 2012 中完全停止了对迁移或运行"DTS 包的支持.即使您说服客户迁移到 SQL 2012，您也必须先将包升级到 2008，然后再升级再次到 2012 年，所以他们越早同意升级到某些 较新的版本越好，尽管我很欣赏这一点——不管是对还是错——许多客户不会看到支付升级仍然有效的东西的意义.

As the documentation says, support for "migrating or running" DTS packages was completely discontinued in SQL Server 2012. Even if you convince your customers to move to SQL 2012, you'll have to upgrade the packages to 2008 first and then upgrade again to 2012, so the sooner they agree to upgrade to some newer version the better, although I appreciate that - rightly or wrongly - many customers will not see the point in paying to upgrade something that still works.

这篇关于在 SQL Server 2012 上运行 DTS 包的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！