在SQL Server 2008上执行SQL Server 7 DTS

I believe its possible to run SQL 2000 DTS packages on 2008 with a compatability layer. But is it possible to do the same with DTS packages created on SQL 7? Is there any MS KB or note that points out if this is even a possibility.

我相信它可以在2008年使用兼容性层运行SQL 2000 DTS包。但是有可能对在SQL 7上创建的DTS包执行相同的操作吗?有没有MS KB或注释指出这是否可能。

2 个解决方案

#1

Haven't found the KB article at Microsoft yet, but here's a bit more info. Doesn't look like you can do what you want w/o moving to SSIS.

尚未在微软找到知识库文章,但这里有更多信息。看起来你不能做你想要的,而不是转移到SSIS。

Version of SQL Server that can be reverted to can be one of the following:

可以还原为的SQL Server版本可以是以下之一:

60 = SQL Server 6.0
65 = SQL Server 6.5
70 = SQL Server 7.0
80 = SQL Server 2000
90 = SQL Server 2005
100 = SQL Server 2008

Note: Compatibility level 60, 65, and 70 [are] no longer available in SQL Server 2008. And future version[s] of SQL Server will support only two (2) prior version[s] of backward compatibility.

注意:SQL Server 2008中不再提供兼容级别60,65和70 [SQL Server]的未来版本[s]将仅支持向后兼容的两(2)个先前版本[s]。

#2

Maybe 2005 but not SQL Server 2008. Can you not move it to SSIS?

也许是2005而不是SQL Server 2008.你能不把它移到SSIS?

#1