Sql server Integration Services 2008-2005 兼容性 [英] Sql server Integration Services 2008-2005 compatibility

问题描述

我最近使用 2008 版本在我的开发机器上开发了一个 SSIS 包.后来我发现客户有 Sql server 2005 并且不打算很快升级.

I recently developed an SSIS package on my dev machine using the 2008 version. Later I foud the customer had Sql server 2005 and doesn't plan to upgrade anytime soon.

有没有办法像降级向导一样将 2008 包变成 SSIS 2005 包?

Is there a way to turn the 2008 package into a SSIS 2005 package, like a downgrade wizard?

推荐答案

我们有一个应用程序可以将 SSIS 包从 2008 版降级到 2005 版.

Courtesy of an unnamed source we have an app to downgrade a SSIS package from the 2008 version to 2005.

虽然它适用于通用组件，但除了 Lookup 之外，不支持任何新组件.

Whilst it works with the common components any new components aren’t supported with the exception of the Lookup.

也不支持第 3 方组件.

3rd party components are also not supported.

它经过了非常有限的测试，并且不是 MS 支持的选项.不建议将其用于生产包.

It was gone through very limited testing and is not a supported option from MS. Its is not advised to use this for production packages.

这是让您摆脱困境的有用工具.

It is a useful tool to get you out of a sticky situation.

http://ssisdowngrade.codeplex.com

这篇关于Sql server Integration Services 2008-2005 兼容性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！