无法打开一个SQL Server 2000 DTS包我导入到SQL Server 2008无法打开、导入到、SQL、Server

2023-09-07 08:43:20 作者:丶 低调控制尖叫

我遇到了一个问题,试图打开一个SQL Server 2000 DTS包我导入到SQL Server 2008中我成立了一个新的服务器,并安装了新安装的SQL Server 2008的我需要运行该数据库是SQL Server 2000数据库。我感动的数据库,通过使用没有问题,但也有需要在传统的SQL Server 2008上运行我出口DTS包,我需要从SQL2000几个DTS包和进口他们顺利到SQL Server 2008中我的SQL Server 2008 64。

I am running into a problem trying to open a SQL Server 2000 DTS package I imported into SQL Server 2008. I set up a new server and installed a fresh install of SQL Server 2008. The database I need to run is a SQL Server 2000 database. I moved the database over with no problem but there are a few DTS packages that need to run in legacy on SQL Server 2008. I exported the DTS packages I need out of SQL2000 and imported them successfully into SQL Server 2008. My SQL Server 2008 is x64.

我可以看到在传统下的数据转换服务DTS包,但是当我尝试打开包装,我得到这个消息。 SQL Server 2000的DTS设计器组件需要编辑DTS包。安装特殊的Web下载,SQL Server 2000的DTS设计器组件以使用此功能。(Microsoft.SqlServer.DtsObjectExplorerUI)

I can see the DTS packages under Data Transformation Service in Legacy but when I try to open the package I get this message. "SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special web download, "SQL Server 2000 DTS Designer components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)"

我下载的组件和安装的话,仍然可以得到这个错误。我研究后发现这个没有工作在x64的文章,所以我有我安装了SQL Server 2008的工具,试图从那里打开包装,并得到了同样的错误在x86机器。

I downloaded the components and installed them and still get this error. I researched and found an article about this not working on x64 so I have an x86 machine that I installed the SQL Server 2008 tools and tried to open the package from there and got the same error.

我花了几天就这个问题和需要帮助。跨越这个有没有人遇到和能告诉我该怎么做。如果你已经解决了这个问题,请大家帮我出。谢谢你。

I have spent days on this and need help. Has anyone run across this and can tell me what to do. If you have solved this problem, please help me out. Thanks.

推荐答案

我有一个类似的问题,最终还是放弃了。

I've had a similar problem and eventually gave up.

我的解决方法是使用以下方法之一:

My workaround was to use one of these approaches:

重写DTS包作为一个存储过程,并安排一个作业运行在适当的情况。 重写DTS包作为一个SSIS过程。 导入遗留DTS包到SQL Server 2005实例,并使用链接的服务器,现在更新的数据库上运行SQL下即成2008年。