开发者

SQL Server: does SQL Server 2008 64 bit support DTS Runtime?

开发者 https://www.devze.com 2023-01-24 04:47 出处:网络
I a开发者_Python百科m looking online and would like to migrate my DTS Packages to SSIS using migration wizard, but when I go to convert packages it says I must Install DTS Runtime, when I look online,

I a开发者_Python百科m looking online and would like to migrate my DTS Packages to SSIS using migration wizard, but when I go to convert packages it says I must Install DTS Runtime, when I look online, at MSDN, it says : When planning to install support for DTS packages, know that SQL Server 2008 does not include support for DTS in the following circumstances:

There is no 64-bit design-time or run-time support for DTS packages. On a 64-bit computer, DTS packages, and Integration Services packages that use the Execute DTS 2000 Package task to run DTS packages, can run only in 32-bit mode.

Can anyone confirm that I cannot use the dts migration wizard on a 64 bit machine in SQL Server 2008?


DTS was deprecated. I would just go ahead and rebuild it using SSIS.

http://msdn.microsoft.com/en-us/library/bb500440.aspx

0

精彩评论

暂无评论...
验证码 换一张
取 消