SQL Server: does SQL Server 2008 64 bit support DTS Runtime?
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
精彩评论