从sql server 2000到2008的dts包的移植 [英] Migraion Of dts Packages from sql server 2000 to 2008

问题描述

如何将sql server 2000的DTS包更新到sql server 2008？

解决方案

更新是什么意思？在SQL Server 2008中有一些DTS的向后兼容性，但它并不完美（我们的一些软件包名称中有撇号，2008年的设计师不会应对它们）。微软的文章： http://msdn.microsoft.com/en- us / library / bb500440％28v = sql.105％29.aspx [ ^ ]。



MS宁愿你把它们变成SSIS，你看的吗？为你做这个工具？



更清楚地概述你的目标，我可以在我的帮助中更具体。

How to update DTS packages of sql server 2000 to sql server 2008?

解决方案

What do you mean by update? There is some backwards compatibility for DTS in SQL Server 2008 but it isn''t perfect (some of our packages had apostrophes in the name and the 2008 designer wouldn''t cope with them). Microsoft article here :http://msdn.microsoft.com/en-us/library/bb500440%28v=sql.105%29.aspx[^].

MS would rather you turned them into SSIS, are you looking for a tool to do that for you?

Outline a little more clearly what you''re aiming to do and I can be more specific in my help.

这篇关于从sql server 2000到2008的dts包的移植的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！