有哪些工具可用于 DTS 到 SSIS 包转换
作为 SQL Server 升级的一部分，有哪些工具可用于将 DTS 转换为 SSIS 包？您推荐哪些工具？
What are the tools available for DTS to SSIS package conversion as a part of the SQL Server upgrade and which ones do you recommend?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
对于拥有数千个软件包的大型公司来说，重写软件包不是一个选择。 前几天，我正在与一位客户打交道，他收到了超过 50 万美元的报价来转换他们的软件包，以及 2 年和 8 名员工。没有人能等那么久才能继续他们的迁移项目。 Pragmatic Works 的 DTS xChange 工具将为您自动完成 90% 的迁移。 该工具目前已迁移超过 200K 个包，并附带一个额外的工具来帮助执行 ActiveX 脚本任务。
Rewriting the packages isn't an option for larger scale companies where they have thousands of packages. I was dealing with a customer the other day that received a quote for more than $500k to convert their packages and 2 years and a staff of 8. No one can wait that long to proceed with their migration project. The DTS xChange tool by Pragmatic Works will automate 90% of the migration for you. The tool has migrated more than 200K packages at this point and comes with an additional tool to help with ActiveX Script Tasks.
如果您有大量软件包，您可以尝试使用 Microsoft 的迁移向导。 它不会迁移所有内容。
它会给你一个美好的开始。
当然，您将彻底测试转换后的包。
来自 http://technet.microsoft.com/en-us/library/cc966519 .aspx
该过程的一些屏幕截图。
http://wiki.sqlis.com/default.aspx/SQLISWiki/MigrationWizardSteps。 html
If you have a large amount of packages, you might try the migration wizard from microsoft. It will not migrate everything.
It will give you a nice start.
Of course you will test the converted packages thoroughly.
From http://technet.microsoft.com/en-us/library/cc966519.aspx
Some screen shots of the process.
http://wiki.sqlis.com/default.aspx/SQLISWiki/MigrationWizardSteps.html
SSIS 比 DTS（尤其是 2008 版本）好得多，因此您最好重写包。
SSIS is so much better than DTS (especially the 2008 version) that you might do better to rewrite the packages.
我不会相信任何这样的工具，如果有的话。 这些转换工具通常仅用作学习辅助工具。
当你有机会时，重写 SSIS 中的包。
编辑：反对票！！！？？？ 天啊！ 那么，你们是否都在运行已从 VB 转换为 .net 的应用程序，以及使用 oracle 到 sql 转换工具转换的数据库？ 我敢打赌你不是。
I wouldn't trust any such tool, if any exist. These conversion tool are typically only any use as a learning aid.
Rewrite the packages in SSIS as and when you get a chance.
EDIT: Downvotes!!?!?? Jeez! So are you guys all out there running apps which have been converted from VB to .net against databases converted using the oracle to sql conversion tool? I'll bet you're not.